mysql查出近7天每日的统计数据?
2021-01-16 22:06:45
select day(createTime) as 日期, count(1) as 数量 from huiya_cover where createTime >= date(now()) - interval 7 day group by day(createTime);