MySQL insert or update in one query

Posted by: Paul on: October 29, 2007

• In: SQL
• Comment!

Another MySQL timesaver:
INSERT INTO Sales(TransId, Status, Amount)
VALUES(123, 'Pending', 20)
ON DUPLICATE KEY UPDATE Status = 'Paid'

Via Particletree