怎样定时执行一个表一个字段的统计啊?
例如,我想每天给user表统计今个星期的点击次数,点击次数在click表
select @coun=count(*) from click where us_id=1 and datediff(day,time,getdate()) <7
update user set click=@coun where id=1
上次是把id=1的今个星期的点击次数更新了...
我怎样把整个user表的统计出来呢?
[解决办法]
update a set
click= b.coun
from [user] a, (
select us_id, coun=count(*) from click where datediff(day,time,getdate()) <7
group by us_id
)b
where a.id=b.us_id
[解决办法]
update user set click= ISNULL(A.icoun,0) from user left join
(
select useid, icoun=count(1) from click where datediff(day,time,getdate()) <7 group by userid
)A
on user.id=A.userid
