Mauricio,
When I had a similar problem, I located it by using MS Excel to compare the original csv file to the results of a SELECT * INTO OUTFILE csv file of the MySQL data. The Excel formula I used was " =a1=ab1 ", where "a1" and "ab1" are the two cells you want to compare.
I found it to be a field formatting problem in my case. I was using 'float' when I needed 'double' in the field definitions. MySQL noted an error for each instance where the results were not *exactly* the same as the input data.
You have a larger dataset than I was using, but you could use the same method with just a few lines of the input data to see if there is an obvious error.
Dan
-----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]
