mysql最近7天销售额_mysql统计最近7天数据

mysql统计最近7天数据

不多说直接上代码：select a.click_date,ifnull(b.count,0) as count_reg

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(FROM_UNIXTIME(reg_time)) as datetime, count(*) as count

from member

group by date(FROM_UNIXTIME(reg_time))

) b on a.click_date = b.datetime;

mysql统计最近7天数据试试吧！