自己构建临时表获取连续日期--最终版

select nowMonth, ifnull(max(count_num),0) as num
from (

	SELECT DATE_FORMAT(date_add('2022-02-01', INTERVAL xc DAY), '%Y-%m-%d') as nowMonth
	FROM ( 
	 SELECT @xi:=@xi+1 as xc from 
	 (SELECT 1 UNION SELECT 2 UNION SELECT 3 UNION SELECT 4 UNION SELECT 5 UNION SELECT 6) xc1, 
	 (SELECT 1 UNION SELECT 2 UNION SELECT 3 UNION SELECT 4 UNION SELECT 5 UNION SELECT 6) xc2,  
	 (SELECT @xi:=-1) xc0 
	) xcxc

) as dtable
left join t_test_date td on td.create_time = dtable.nowMonth
where DATE_FORMAT(nowMonth, ‘%Y-%m’) = DATE_FORMAT(now(), ‘%Y-%m’)
GROUP BY dtable.nowMonth
ORDER BY dtable.nowMonth asc

SELECT DATE_FORMAT(DATE_SUB(‘2022-01-09’, INTERVAL d DAY), ‘%Y-%m-%d’) as year_month_day
FROM (
select d from (
SELECT @xi:=@xi+1 as d from
(SELECT 1 UNION SELECT 2 UNION SELECT 3 UNION SELECT 4 UNION SELECT 5) xc1,
(SELECT 1 UNION SELECT 2 UNION SELECT 3 UNION SELECT 4 UNION SELECT 5) xc2,
(SELECT @xi:=-1) xc0
) as m where d <= 5
) dtc

瞎写点东西
瞎写点东西
select
coalesce((case when CONCAT(vsc.run_date,’’) = ‘2021-07-01’ then max(vsc.electric_control_max) END),0) as ‘2021-07-01’ ,
(case when CONCAT(vsc.run_date,’’) = ‘2021-07-02’ then max(vsc.electric_control_max) END) as ‘2021-07-02’ ,
(case when CONCAT(vsc.run_date,’’) = ‘2021-07-03’ then max(vsc.electric_control_max) END) as ‘2021-07-03’ ,
(case when CONCAT(vsc.run_date,’’) = ‘2021-07-04’ then max(vsc.electric_control_max) END) as ‘2021-07-04’ ,
coalesce((case when CONCAT(vsc.run_date,’’) = ‘2021-07-21’ then max(vsc.electric_control_max) END),0) as ‘2021-07-21’