mysql获取1000天内的连续时间段.

 select * from (
 
     select a.hours    
                    from (
                            select SUBSTRING('2019-05-06 00:00:00',1,10) - INTERVAL (a.a + (10 * b.a) + (100 * c.a)) DAY as hours
                            from (select 0 as a union all select 1 union all select 2 union all select 3 union all select 4 union all select 5 union all select 6 union all select 7 union all select 8 union all select 9) as a
                            cross join (select 0 as a union all select 1 union all select 2 union all select 3 union all select 4 union all select 5 union all select 6 union all select 7 union all select 8 union all select 9) as b
                            cross join (select 0 as a union all select 1 union all select 2 union all select 3 union all select 4 union all select 5 union all select 6 union all select 7 union all select 8 union all select 9) as c
                    ) a
                    where a.hours between DATE_ADD('2019-05-01 00:00:00',INTERVAL -1 day) and '2019-05-09 00:00:00'; )
                
  原理, 利用sql 得到连续1到1000的自然数, 在利用日期,分别减去这1000个自然数,就是每一天的日期. 

功能: 常用于,多个字段分组, 比如按天.按地区. 无数据,当天补0.  配合前端做图表展示