mysql 范围内日期列表_MySQL：选择一个范围内的所有日期,即使没有记录

我希望你能弄清楚其余的。

select * from (

select date_add('2003-01-01 00:00:00.000', INTERVAL n5.num*10000+n4.num*1000+n3.num*100+n2.num*10+n1.num DAY ) as date from

(select 0 as num

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) n1,

(select 0 as num

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) n2,

(select 0 as num

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) n3,

(select 0 as num

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) n4,

(select 0 as num

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) n5

) a

where date >'2011-01-02 00:00:00.000' and date < NOW()

order by date

同

select n3.num*100+n2.num*10+n1.num as date

您将得到一列，数字从0到最大(n3)* 100最大(n2)* 10最大(n1)

由于这里我们的最大n3为3，所以SELECT将返回399，加0→& 400条记录(日历中的日期)。

您可以通过限制来调整动态日历，例如，从最小(日期)到现在()。