统计最近7天的数据(统计)

查询数据库表中最近7天的记录（用于做统计）

MySQL 代码

select date_format(a.date,'%c.%d') day,b.count,b.amount
from (
SELECT  curdate() as date
union all
SELECT date_sub(curdate(), interval 1 day) as date
union all
SELECT date_sub(curdate(), interval 2 day) as date
union all
SELECT date_sub(curdate(), interval 3 day) as date
union all
SELECT date_sub(curdate(), interval 4 day) as date
union all
SELECT date_sub(curdate(), interval 5 day) as date
union all
SELECT date_sub(curdate(), interval 6 day) as date
) a left join (
select date(时间字段) as datetime, count(*) as count
from 表名 where 查询
group by date(时间字段)
) b on a.date= b.datetime order by a.date

							             SQL执行结果

前端我用到的是echarts插件 效果如下（自行调整）