INSERT INTO mobile_uv_channel_temp SELECT appid,channelname,avg(uv) FROM `mobile_uv_channel` WHERE inputdate BETWEEN '2011-09-26' and '2011-09-27' GROUP BY appid,channelname
UPDATE `mobile_uv_channel` as a ,mobile_uv_channel_temp as b
set a.uv = b.uv WHERE a.inputdate = '2011-09-25' and a.appid = b.appid and a.channelname = b.channelname
UPDATE `mobile_uv_channel` as a ,mobile_uv_channel_temp as b
set a.uv = b.uv WHERE a.inputdate = '2011-09-25' and a.appid = b.appid and a.channelname = b.channelname
扫一扫
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
