如何在插入多行时使用"ON DUPLICATE UPDATE“递增MySql中的字段?
对于一行:
INSERT INTO table
(a, counter_elem)
VALUES
(1, 1)
ON DUPLICATE KEY UPDATE counter_elem = counter_elem+1;对于多行:
INSERT INTO table
(a, counter_elem)
VALUES
(1, 1),
(2, 1)
ON DUPLICATE KEY UPDATE counter_elem = ?;这不起作用:
counter_elem = VALUES(counter_elem)+1发布于 2011-07-24 02:16:24
完全一样的方式!
INSERT INTO table
(a, counter_elem)
VALUES
(1, 1),
(2, 1)
ON DUPLICATE KEY UPDATE counter_elem = counter_elem + 1;这没什么问题!
https://stackoverflow.com/questions/6802239
复制相似问题