使用INSERT ... ON DUPLICATE KEYUPDATE
。例如:
INSERT INTO `usage`
(`thing_id`, `times_used`, `first_time_used`)
VALUES
(4815162342, 1, Now())
ON DUPLICATE KEY UPDATE
`times_used` = `times_used` + 1
如何更新是否存在(如果存在),如果不存在则插入(又称“伪装”或“合并”)在MySQL中?
使用INSERT ... ON DUPLICATE KEYUPDATE
。例如:
INSERT INTO `usage`
(`thing_id`, `times_used`, `first_time_used`)
VALUES
(4815162342, 1, Now())
ON DUPLICATE KEY UPDATE
`times_used` = `times_used` + 1