PHP Mysql Duplicate Entry Error for Unique Column

Question

I have a ton of data I have to parse and insert into a mysql database.

Some of it is duplicate, so I setup a unique index on the column that needs to be unique.

Instead of running the insert queries 1 by 1, I'm doing batches of 100 to lessen the load on the DB. However if I get a duplicate entry error, it seems that entire batch is not inserted. Is there a way to structure the query to say "if there are duplicates ignore those but please insert the rest of the data"?

Thanks in advance.

Borniet · Accepted Answer · 2013-05-10 12:59:20Z

1

You can use the IGNORE keyword for that: http://dev.mysql.com/doc/refman/5.5/en/insert.html

answered May 10, 2013 at 12:59

Borniet

3,5564 gold badges26 silver badges33 bronze badges

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

Collectives™ on Stack Overflow

PHP Mysql Duplicate Entry Error for Unique Column

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related