I want to see the warnings when load data from text file using command mysal> load data local infile 'mydata.txt' into table my_table;
When I got Query OK, 1431 rows affected, 1506 warnings (0.27 sec) Records:1431 Deleted: 0 Skipped:0 Warnings:1506 I have to find out what cause the warnings. I found column size is one problem and by fixing one column size, 1400 warnings were gone. Maybe the remaining 1506 warnings are related to column definition or null data in the file etc, but where can i see the warnings themselves? Thanks -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
