Hello Mauricio, I tested in version 4.1.0 and not function. Only in version 4.1.1, according to text below extracted from MySQL manual:
Note that the framework for warnings was added in MySQL 4.1.0, at which point many statements did not generate warnings. In 4.1.1, the situation is much improved, with warnings generated for statements such as LOAD DATA INFILE and DML statements such as INSERT, UPDATE, CREATE TABLE, and ALTER TABLE. Regards, Renato Cramer. -----Mensagem original----- De: Mauricio Pellegrini [mailto:[EMAIL PROTECTED] Enviada em: quinta-feira, 3 de junho de 2004 13:20 Para: MySql List Assunto: 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]