MySQL显示范围之间的所有日期

您可以使用以下命令生成日期列表：

select a.Date,  s.*from (  select curdate() + INTERVAL (a.a + (10 * b.a) + (100 * c.a)) DAY as Date  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) ainner join schedule s  on a.Date >= s.fromDate   and a.Date <= s.toDate

参见带有演示的SQL Fiddle