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’