List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:June 14 2002 1:10pm
Subject:Re: load data infile and warnings
View as plain text  
At 12:52 +0200 6/14/02, Harald Fuchs wrote:
>In article <p0511176fb92e694753f3@[]>,
>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:
>>  Look for the note.
>Thanks for the interesting hint.  However, there's something I don't
>quite understand: 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:
>   (the manual)
>           (the list archive)
>To request this thread, e-mail <mysql-thread111968@stripped>
>To unsubscribe, e-mail <>
>Trouble unsubscribing? Try:

load data infile and warningsOliver Vecernik13 Jun
  • Re: load data infile and warningsPaul DuBois13 Jun
  • Re: load data infile and warningsHarald Fuchs14 Jun
    • Re: load data infile and warningsPaul DuBois14 Jun
  • Re: load data infile and warningsVictoria Reznichenko14 Jun