Showing posts with label ignore duplicates. Show all posts
Showing posts with label ignore duplicates. Show all posts

Wednesday, May 22, 2013

How to update mysql table ignoring the duplicate fields that are already present

here's how you do it.


INSERT INTO thetable (pageid, name, somefield)
VALUES (1, "foo", "first")
ON DUPLICATE KEY UPDATE (somefield = 'first')
taken from