You need version 4.1.x and greater. Then issue SHOW WARNINGS after the statement that generated the warnings.
-----Original Message----- From: Mauricio Pellegrini To: MySql List Sent: 6/3/04 11:20 AM Subject: How to retrieve MySQL Warning Messages Hi, Mysql 4.018 , SuSE 8.2. I'm using LOAD DATA LOCAL INFILE "/xxxx/yyyy.txt" INTO TABLE zz_zzz ; and I get the following message Query OK, 158063 rows affected (1 min 36.49 sec) Records: 158063 Deleted: 0 Skipped: 0 Warnings: 158115 Nothing seems to be wrong with the table after executing the command. I would like to know the cause of the WARNINGS or what is the text corresponding to those warnings Is that possible? Thank you Mauricio -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]