I'm loading a large csv file and get the following result:
mysql> LOAD DATA LOCAL INFILE "kanji_all.csv" INTO TABLE kanji_all
-> FIELDS TERMINATED BY "," ENCLOSED BY "\"" IGNORE 1 LINES;
Query OK, 6355 rows affected (1.27 sec)
Records: 6355 Deleted: 0 Skipped: 0 Warnings: 49821
The resulting table looks fine (hard to tell), but I'd like to know what
all the warnings are. I've looked though the manual, book, tried logs
etc. but I can't find their content.
(mysql Ver 10.8 Distrib 3.23.22-beta, for redhat-linux-gnu (i386))
Thanks in advance,
Malcolm
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php