Insert ignore to avoid updating existing record

From MyWiki

Jump to: navigation, search

INSERT INTO users_partners (uid,pid) VALUES (1,1);
...1 row(s) affected
 
INSERT INTO users_partners (uid,pid) VALUES (1,1);
...Error Code : 1062
...Duplicate entry '1-1' for key 'PRIMARY'
 
INSERT IGNORE INTO users_partners (uid,pid) VALUES (1,1);
...0 row(s) affected
 
INSERT INTO users_partners (uid,pid) VALUES (1,1) ON DUPLICATE KEY UPDATE uid=uid
...0 row(s) affected

Retrieved from "https://wiki.twig.es/index.php?title=Insert_ignore_to_avoid_updating_existing_record&oldid=2968"