Re: load data infile and warnings

2002-06-14 Thread Paul DuBois
At 12:52 +0200 6/14/02, Harald Fuchs wrote: >In article , >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

Re: load data infile and warnings

2002-06-14 Thread Victoria Reznichenko
Oliver, Thursday, June 13, 2002, 5:39:52 PM, you wrote: OV> I imported a text file and got following results: OV> mysql> load data local infile 'update.txt' into table PLZV lines OV> terminated by '\r\n' ignore 2 lines; OV> Query OK, 46658 rows affected (0.66 sec) OV> Records: 46658 Deleted: 0

Re: load data infile and warnings

2002-06-13 Thread Paul DuBois
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 War

load data infile and warnings

2002-06-13 Thread Oliver Vecernik
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