mysql 计数怎么用_Mysql -- 统计类用法

累加:

update push_online a,

(select msg_key, push_count

from push_online)b

set a.push_count=b.push_count + 111

where a.msg_key=b.msg_key;

插入新的

insert into push_online (msg_key,push_count) values ("32123132",123) ON DUPLICATE KEY UPDATE  push_count=push_count+123;

批量插入新的:

insert into push_online (msg_key,push_count) values ("2676db91e7ac691f1d3e4059d4220081",12) ON DUPLICATE KEY UPDATE  push_count=values(push_count)