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-14 Thread Paul DuBois
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

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

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 Warnings: 4