mysql 表如果 key相同则累加，不相同则插入

product_id和op_date为联合主键

--插入登录用户数量

insert into daily_data(`product_id`,`op_date`,`login_num`) 
  (
select product_id,date_format(op_date, '%Y%m%d'),count(uid) from dev_user_logs.login_log where product_id is not null GROUP BY date_format(op_date, '%Y%m%d'),product_id


) on duplicate key update `login_num`=`login_num`+values(`login_num`)




--插入安装用户数量
insert into daily_data(`product_id`,`op_date`,`install_num`) 
  (
select product_id,date_format(op_date, '%Y%m%d'),count(uid) from dev_user_logs.install_log where product_id is not null GROUP BY date_format(op_date, '%Y%m%d'),product_id


) on duplicate key update `install_num`=`install_num`+values(`install_num`)



--删除昨天和今天的。

delete from daily_data where to_days(op_date) = to_days(now()) || and to_days(now())-to_days(op_date) = 1