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

No comments:

Post a Comment