How to ignore an insert of already exisiting unique value?

Question

Suppose I have a table keywords(keyid, keyword), with keyid being the primary key and keyword being varchar and unique.

How can I insert non-existing values and ignore the values that already exist in the table without getting an error?

For example I insert a, b, c, d. Then I insert c, d, e, f. It should ignore c and d, and insert e and f.

Via `INSERT IGNORE INTO...` http://dev.mysql.com/doc/refman/5.5/en/insert.html or take different action via `ON DUPLICATE KEY...` — Michael Berkowski, May 12 '13 at 16:05
possible duplicate of ["INSERT IGNORE" vs "INSERT ... ON DUPLICATE KEY UPDATE"](http://stackoverflow.com/questions/548541/insert-ignore-vs-insert-on-duplicate-key-update) — Michael Berkowski, May 12 '13 at 16:07

score 0 · Accepted Answer · answered May 12 '13 at 16:06

0

INSERT INTO keywords (keyid, keyword) 
     VALUES (100, 'a keyword') 
         ON DUPLICATE KEY UPDATE keyid = keyid;

This way the alternative UPDATE is executed, if keyid already exists.

Cheers!

answered May 12 '13 at 16:06

Trinimon

score 0 · Answer 2 · answered May 12 '13 at 16:06

0

You can use ON DUPLICATE KEY UPDATE function. Documentation here

Example

INSERT INTO table (a,b,c) VALUES (1,2,3)
ON DUPLICATE KEY UPDATE c=c+1;

answered May 12 '13 at 16:06

Fabio

2 Answers2