INSERT INTO test1(a,b,c) VALUES(2,2,2) ON DUPLICATE KEY UPDATE a = 4 ,b = VALUES(b) ,c = VALUES(c)
插入时存在就更新语句(通过唯一键判断)
最新推荐文章于 2021-02-28 04:16:35 发布
INSERT INTO test1(a,b,c) VALUES(2,2,2) ON DUPLICATE KEY UPDATE a = 4 ,b = VALUES(b) ,c = VALUES(c)