有两个表logonlog(每次用户登陆的统计),logontotal(每天,每周,每月用户登陆的统计),现在想将logonlog中数据统计加入倒logontotal中,如何实现,请教高人了。
结构:
logonlog:
[USERID] [varchar] ,
[LOGONTIME] [datetime] ,logontotal:[USERID] [varchar]
[DAYCOUNT] [int]
[WEEKCOUNT] [int] ,
[MONTHCOUNT] [int] ,
[YEARCOUNT] [int] ,
[TOTAL] [int]
结构:
logonlog:
[USERID] [varchar] ,
[LOGONTIME] [datetime] ,logontotal:[USERID] [varchar]
[DAYCOUNT] [int]
[WEEKCOUNT] [int] ,
[MONTHCOUNT] [int] ,
[YEARCOUNT] [int] ,
[TOTAL] [int]
逐条读logonlog,对容器中的相对应的数据++就可以了吧
一年十二月,一月四周,一周七天,logontotal是咋对应的呀