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