Re: insert warning - how to look at

2009-10-30 Thread Johan Andersson
Hi, mysql show warnings; BR johan Sydney Puente wrote: Hello, I have an application which is inserting rows into a Mysql 5.024 db. It seems to stop when an insert generates a warning. when I insert the suspect line on the mysql commandline I get this: Query OK, 1 row affected, 1 warning

Re: insert warning - how to look at

2009-10-30 Thread Sydney Puente
Thanks johan, Very useful - it seems so obvious now! There is an associated problem with transferring data into mysql. because if the application pushing the data finds a warning it just silently stops. anyway I can detect a warning 1265 Data truncated on the mysqldb? and make this visible - at

RE: insert warning - how to look at

2009-10-30 Thread Jerry Schwartz
-Original Message- From: Sydney Puente [mailto:sydneypue...@yahoo.com] Sent: Friday, October 30, 2009 10:36 AM To: mysql@lists.mysql.com Subject: Re: insert warning - how to look at Thanks johan, Very useful - it seems so obvious now! There is an associated problem with transferring data