Update nothing on duplicate key exist

Question

I'm using the query INSERT INTO ... ON DUPLICATE KEY UPDATE ... in order to insert a record into the table, and if a row with duplicate keys already exists, this results in triggering an update.

I don't want any updates being performed on an existing row, if exist.

What should I do to update nothing when a row with duplicate keys exist?

Put more effort to your questions pls... Elaborate more and provide details of your problem. — mrjimoy_05, Dec 16 '12 at 09:18
You could see if there's an element with duplicate key before inserting — Ranty, Dec 16 '12 at 09:32
**Duplicate of:** [stackoverflow.com/q/4596390](https://stackoverflow.com/q/4596390/1454514) — David Refoua, Sep 03 '21 at 06:58

score 2 · Accepted Answer · answered Dec 16 '12 at 13:57

2

just set the unique value with the original value, (Assuming ProductID is unique) eg,

INSERT INTO CART (ProductID, Quantity)
VALUES (1, 100)
ON DUPLICATE KEY UPDATE ProductID = ProductID;

answered Dec 16 '12 at 13:57

John Woo

249,283
65
481
481

Update nothing on duplicate key exist

1 Answers1