Insert a record with duplicate keys (MySQL)

23 Sep 2013

You can bypass that by using:

  • REPLACE
  • INSERT … ON DUPLICATE KEY UPDATE
  • INSERT IGNORE (a bad one because it also ignores other errors)

Give it a kudos