CSV Import to MySQL with PHP skip duplicates

Question

I have a PHP script that imports a csv into a MySQL database. The import works fine using this line of code

$query = "insert into $databasetable values('$linemysql');";

The only problem is when I try to import another csv with duplicates the script errors out. How do I adjust this script to skip duplicates if they exist?

lafor · Accepted Answer · 2012-04-20 10:25:31Z

4

INSERT IGNORE won't insert a row if that would result in a duplicate key. However, it will also ignore (and not generate an error) some other cases like trying to insert NULL into a column with NOT NULL constraint.

If you just want to ignore duplicates but still get other insert errors, use INSERT ... ON DUPLICATE KEY UPDATE instead. This will update rows with duplicating keys, although comes with some performance cost.

answered Apr 20, 2012 at 10:25

lafor

12.8k4 gold badges34 silver badges36 bronze badges

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

1 Comment

danp Over a year ago

didn't know about those keywords +1 :)

ilanco · Accepted Answer · 2012-04-20 10:12:30Z

2

if you are using mysql try:

$query = "insert ignore into $databasetable values('$linemysql');";

answered Apr 20, 2012 at 10:12

ilanco

10.1k4 gold badges34 silver badges37 bronze badges

Collectives™ on Stack Overflow

CSV Import to MySQL with PHP skip duplicates

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related