Removed by Administrator
Hi, I just loaded 71,000 records using "load data infile" and when done it gave no warnings, but said it skipped 4. Is there any record anywhere of which 4 records didn't get loaded or any other info about it? I know about the show warnings, but didn't find any "show skipped" command? I have also searched all the server log files. I am using mysqld 4.1.11 and Innodb. I am assuming that either the data had some bad syntax, or that referential integrity wasn't met. I didn't "set foreign_key_checks=0" .. If the 4 records got skipped because of referential ...
Hi,
I just loaded 71,000 records using "load data infile" and when done it
gave no warnings, but said it skipped 4. Is there any record anywhere
of which 4 records didn't get loaded or any other info about it?
I know about the show warnings, but didn't find any "show skipped"
command?
I have also searched all the server log files. I am using mysqld
4.1.11 and Innodb.
I am assuming that either the data had some bad syntax, or that
referential integrity wasn't met. I didn't "set foreign_key_checks=0"
..
If the 4 records got skipped because of referential integrity checks,
will it say so, or does it always only give the message about
"deleted:0 skipped:4 warnings:0"
thanks in advance..
Roshan
Removed by Administrator
Thanks a lot Bill for your reply. After reading your post, I decided
to try to make sure my primary key was unique for each row. Sure
enough I got 4 rows with duplicate entries, so that was my problem.
Back to the drawing board to figure out the primary key.
Roshan
Bookmarks