mysql 无数据的显示0_使用Mysql 统计一周数据，若没有数据显示为0

select a.click_date,IFNULL(b.count,0) as couns,IFNULL(b.totprice,0) as totprice

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(order_pay_time) as datetime, count(*) as count,sum(order_fee_total_pay) as totprice

from sys_order

where seller_id=12

group by date(order_pay_time) ASC

) b on a.click_date = b.datetime;

//参考https://blog.csdn.net/ouyang1...