Duplicate Key Error

rakennedy75

I am using the phpMyAdmin app and I am installing a text file that creates a table and its rows and loads a txt file into it. phpMyAdmin prints out a statement that ...

Error
SQL-query
LOAD DATA INFILE 'myPath/myTextFile.txt' INTO TABLE myTable FIELDS TERMINATED BY ',' ENCLOSED BY '\"' 

MySQL sad:
#1062 - Duplicate entry '100' for key 1

What does it mean by duplicate error, is it in the actual text file that is being imported?

bastien

you have created a index on some field with a unique attribute or a primary key field that is getting duplicated in the data file you want to load...

you could code to write out the 'bad' records to a text file or another table and then handle those after the initial load is complete

rakennedy75

ok, I guess I am a little confused, is actual text file causing the error. In this case I am useing a csv file.

I have created an identical table with the same fields but a different txt file and dfferent table name, and this works fine. I hope that made sense. So I could only conclude that the problem is coming from the csv file.

I guess I don't see how the csv file would have anything to do with duplicating fields. Maybe I am not understanding the problem clearly.

Thanks for your time.

bastien

whats the table structure? can you dump it here?

rakennedy75

unfortunately i have to load in data from a third parties data

create table myTable
(
  dealer char(35) not null,
  vin char(30) not null,
  stock char(15) not null,
  extra1 char(20) not null,
  make char(30) not null,
  model char(30) not null,
  year char(4) not null,
  miles char(10) not null,
  trim char(30) not null,
  cylinder char(20) not null,
  engine1 char(20) not null,
  engine2 char(20) not null,
  trans char(20) not null,
  color char(25) not null,
  price char(10) not null,
  extra2 char(20) not null,
  extra3 char(20) not null,
  extra4 char(20) not null,
  etra5 char(20) not null,
  newDetails text not null,
  clientId char(20) not null,
  id int not null auto_increment primary key 
);

I hope this helps

bastien

If there are no other keys/indeces on the table, other than primary ID key field, then it shouldn't be a problem? Are you loading the ID field from the csv file?

rakennedy75

Ok, you know what, I feel kind of foolish, I should have checked the data more closely. The data csv file I recieved is kind of funky. It has a series of blank records and than a bunch of records filled in. I am guessing that is causing the problem. Sorry for wasting your time but I do appreciate your help.

I just need to check my files more carefully.

Thanks again

bastien

yeah, the blanks will do that...glad you solved the problem