«
»

ON DUPLICATE KEY do nothing

Sometimes you just don’t want to do anything if a key already exists in the DB.

mysql> INSERT INTO `table` SET id=5, name=`arthur` ON DUPLICATE KEY UPDATE 0+0;

Source

Share|

Tags:

This entry was posted on Monday, October 27th, 2008 at 4:27 pm and is filed under MySQL. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

2 Responses to “ON DUPLICATE KEY do nothing”

  1. Mighty Webdeveloper says:
    August 30, 2011 at 6:59 am

    Thanks, was looking for this.

  2. Mighty Webdeveloper says:
    August 30, 2011 at 7:16 am

    Or use:
    INSERT IGNORE INTO `table` SET id=5, name=`arthur`

Leave a Reply