mysql 统计一周数据默认补0

最新推荐文章于 2023-02-23 14:24:09 发布

xiaohenew

最新推荐文章于 2023-02-23 14:24:09 发布

阅读量657

点赞数

分类专栏： mysql 文章标签： mysql 统计一周数据默认补0

本文链接：https://blog.csdn.net/xiaohenew/article/details/86611063

版权

mysql 专栏收录该内容

4 篇文章 0 订阅

订阅专栏

mysql 统计一周数据默认补0

select a.click_date,ifnull(b.count,0) as count
from (
SELECT curdate() as click_date
union all
SELECT date_sub(curdate(), interval 1 day) as click_date
union all
SELECT date_sub(curdate(), interval 2 day) as click_date
union all
SELECT date_sub(curdate(), interval 3 day) as click_date
union all
SELECT date_sub(curdate(), interval 4 day) as click_date
union all
SELECT date_sub(curdate(), interval 5 day) as click_date
union all
SELECT date_sub(curdate(), interval 6 day) as click_date
) a left join (
select date(create_time) as datetime, count(*) as count
from arms_task
group by date(create_time)
) b on a.click_date = b.datetime;