At 12:52 +0200 6/14/02, Harald Fuchs wrote:
>In article <p0511176fb92e694753f3@[192.168.0.33]>,
>Paul DuBois <paul@stripped> 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 <mysql-thread111968@stripped>
>To unsubscribe, e-mail <mysql-unsubscribe-paul=snake.net@stripped>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
