How to increment a field in MySql using "ON DUPLICATE KEY UPDATE" when inserting multiple rows?
For one row:
INSERT INTO table
(a, counter_elem)
VALUES
(1, 1)
ON DUPLICATE KEY UPDATE counter_elem = counter_elem+1;
For multiple rows:
INSERT INTO table
(a, counter_elem)
VALUES
(1, 1),
(2, 1)
ON DUPLICATE KEY UPDATE counter_elem = ?;
This doesn't work:
counter_elem = VALUES(counter_elem)+1
Aucun commentaire:
Enregistrer un commentaire