At 12:52 +0200 6/14/02, Harald Fuchs wrote: >In article <p0511176fb92e694753f3@[192.168.0.33]>, >Paul DuBois <[EMAIL PROTECTED]> writes: > >>> 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. > >Thanks for the interesting hint. However, there's something I don't >quite understand: load_diag.pl creates a temporary table named by >default "_load_diag_<process_id>". Why don't you use a "CREATE >TEMPORARY TABLE load_diag" instead? You would not have to mess with >process IDs or "DROP TABLE IF EXISTS".
For MySQL < 3.23. > >--------------------------------------------------------------------- >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 --------------------------------------------------------------------- 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
