April 23rd, 2000, 07:51 PM
I am working with LOAD DATA INFILE (to add LOTS of data to a database). I loaded a large text file with data, but the command only went through about half of the data. I did receive an error that a Primary Key found multiple of one thing.. would that stop the competion of loading the data?
April 24th, 2000, 02:53 AM
i think your database is having a primary key.i guess some values in your textfile are duplicating .That is why it's giving an error.just check it out your textfile values.
April 24th, 2000, 08:30 PM