mysql按天查询没有数据补0_mysql按天分组统计，没有数据补0的解决方法

一、查询2019-01-10至2019-01-25时间段的数据以下 ：sql

SQL语句为：echarts

SELECT DATE_FORMAT(z.create_date,'%Y-%m-%d') AS days, IFNULL(SUM(z.difMinute)/(SUM(z.dailyLoadTime)*SUM(z.difDays)),0) AS "AR",IFNULL(SUM(z.goodQuant)/(SUM(z.dailyProduceQuant)*SUM(z.difDays)),0) AS "PR",

IFNULL(SUM(z.goodQuant)/SUM(z.goodQuant+z.workWasteQuant+z.materialWasteQuant+z.otherQuant),0) AS "QR",z.difDays

FROM (

SELECT a.id,

mrfc.create_date,

IFNULL(mrfc.good_quant,0) AS "goodQuant",

IFNULL(mrfc.work_waste_quant,0) AS "workWasteQuant",

IFNULL(mrfc.material_waste_quant,0) AS "materialWasteQuant",

IFNULL(mrfc.other_quant,0) AS "otherQuant",

a.device_code,

a.device_name,

a.device_status,

IFNULL(a.daily_load_time,0) AS "dailyLoadTime",

IFNULL(a.daily_produce_quant,0) AS "dailyProduceQuant",

a.corp_id,

a.status_flag,

(UNIX_TIMESTAMP(mrfc.create_date) - UNIX_TIMESTAMP(b.create_date))/60 AS 'difMinute',

(DATEDIFF(mrfc.create_date,b.create_date)+1) AS 'difDays'

FROM mes_report_flow_card mrfc

LEFT JOIN mes_device a ON a.id = mrfc.device_id1

LEFT JOIN mes_report_flow_card b ON b.id = mrfc.report_start_id

WHERE mrfc.create_date BETWEEN '2019-01-10 10:33' AND '2019-01-25 10:33'

AND mrfc.is_report='1'