create table ftclicksum(campaignname varchar(45),user_name varchar(45),clicknum int);create index idx_cam on ftclicksum(campaignname);create index idx_user_name on ftclicksum(user_name);insert into ftclicksum
SELECT campaignname,
user_name,
count(*) as clicknum
FROM ftclick
group by campaignname,user_name;
SELECT campaignname,
user_name,
count(*) as clicknum
FROM ftclick
group by campaignname,user_name;
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货