INSERT IGNORE INTO sl_test(id, num, time) VALUES(2, 1, '2022-11-04 10:46:40') ON DUPLICATE KEY UPDATE num = IF(time = VALUES(time), num, num + VALUES(num));
mysql如果数据已存在则更新累加,如果当前更新数据已是更新累加了则忽略
最新推荐文章于 2023-04-18 19:09:11 发布
INSERT IGNORE INTO sl_test(id, num, time) VALUES(2, 1, '2022-11-04 10:46:40') ON DUPLICATE KEY UPDATE num = IF(time = VALUES(time), num, num + VALUES(num));