How to prevent duplicate records in MYSQL Table when i insert data fetch from CSV file

Question

while (($test= fgetcsv($file, 10000, ",")) !== FALSE){
    $field1= $test[0]; 
    $field2= $test[1];
    $sql= "INSERT IGNORE into tablename(field1, field2) values('$field1','$field2')"; 
    mysql_query($sql);
}

I am importing data from a CSV file and then store this data into variables $field1 , $field2 then I try to insert into tablename table. IN CSV file i have many records. My query insert the data but its inserting duplicate records i use IGNORE in query but its not working for me. How Can i prevent duplication?

fancyPants · Accepted Answer · 2013-11-08 12:26:33Z

1

You need to have a primary key or a unique key in your table. Please refer to the manual.

answered Nov 8, 2013 at 12:26

fancyPants

52.1k34 gold badges94 silver badges100 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

user2964497 Over a year ago

My Table first field is AUTO INCREMENTED with UNSIGNED attribute tableID

fancyPants Over a year ago

Please post the result of SHOW CREATE TABLE your_table_name;

gardni · Accepted Answer · 2013-11-08 12:29:36Z

0

If all you want is to combine duplicated rows, use SELECT DISTINCT.

answered Nov 8, 2013 at 12:29

gardni

1,4343 gold badges28 silver badges53 bronze badges

Collectives™ on Stack Overflow

How to prevent duplicate records in MYSQL Table when i insert data fetch from CSV file

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related