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

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 wo

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 (0.0

insert warning - how to look at

2009-10-30 Thread Sydney Puente
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 (0.05 sec) Other inserts that succeed seem not to generate warni