How to ommit 1062 error, ie add only not-duplicate rows without causing error?

Question

Duplicate of "INSERT IGNORE" vs "INSERT ... ON DUPLICATE KEY UPDATE"

Answer 1

INSERT IGNORE INTO `table` VALUES ("val1"), ("abc")

or

INSERT IGNORE INTO `table` SET columnname1="val1"

Answer 2

Check your table first if the pair of values already exists. If it does simply don't make the insert.

Answer 3

three things you can do.

• You can check before insert if the key pair already exists.
• Look at INSERT IGNORE syntax
• You can wrap your code in try catch if you are using PDO to override this error. I personally am not in favor of this but works great

Answer 4

You can use INSERT IGNORE. No need to check anything - it brings additional overhead.