使用这个语法的表,在操作表必须有唯一建(不一定是主键)
insert into t1 (cn1,cn2)
values(?,?)
on DUPLICATE KEY
UPDATE cn2 = ?
测试 创建表
create table user_ad_count
( dt date,
userid char(2),
adid char(2),
count BIGINT,
primary key (dt,userid,adid)
);
insert into user_ad_count (dt,userid,adid,count)
VALUES ('2020-03-04','1','2','50')
ON DUPLICATE KEY
UPDATE count=70