sql 记录日周月点击

需要字段：

字段 类型 含义 id int 索引ID click_date datetime 最后点击时间 click_sum int 总点击数 click_month int 月点击数 click_week int 周点击数 click_day int 日点击数

update tablename set click_sum=click_sum+1,click_day=IF(DATEDIFF(CURDATE(),click_date)>0,1,click_day+1),click_week=IF(    DATEDIFF(CURDATE(),click_date)>6,1,    IF(WEEKDAY(CURDATE())<WEEKDAY(click_date),1,click_week+1)        ),click_month=IF(    DATEDIFF(CURDATE(),click_date)>30,1,    IF(DAY(CURDATE())<DAY(click_date),1,click_month+1)        ),click_date=Now() where id = 1;