At 16:39 +0200 6/13/02, Oliver Vecernik wrote: >Hi, > >I imported a text file and got following results: > >mysql> load data local infile 'update.txt' into table PLZV lines >terminated by '\r\n' ignore 2 lines; >Query OK, 46658 rows affected (0.66 sec) >Records: 46658 Deleted: 0 Skipped: 0 Warnings: 4 > >Where are the warnings stored? Can I find out what went wrong during >the import?
If you have DBI installed so that you can run MySQL Perl scripts: http://www.kitebird.com/mysql-cookbook/ Look for the load_diag.pl note. > >Oliver --------------------------------------------------------------------- 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
