如何获取MySQL中的两个日期之间的日期列表选择查询[重复]

Question

这个问题已经在这里有了答案 ：

获取两个日期之间的日期列表 （19个答案）

7年前关闭。

我想通过选择查询将日期列表放在两个日期之间。例如：

如果我给出“ 2012-02-10”和“ 2012-02-15”，则需要结果。

date      
----------
2012-02-10
2012-02-11
2012-02-12
2012-02-13
2012-02-14
2012-02-15

我怎样才能得到？

Answer 1

尝试：

select * from 
(select adddate('1970-01-01',t4.i*10000 + t3.i*1000 + t2.i*100 + t1.i*10 + t0.i) selected_date from
 (select 0 i union select 1 union select 2 union select 3 union select 4 union select 5 union select 6 union select 7 union select 8 union select 9) t0,
 (select 0 i union select 1 union select 2 union select 3 union select 4 union select 5 union select 6 union select 7 union select 8 union select 9) t1,
 (select 0 i union select 1 union select 2 union select 3 union select 4 union select 5 union select 6 union select 7 union select 8 union select 9) t2,
 (select 0 i union select 1 union select 2 union select 3 union select 4 union select 5 union select 6 union select 7 union select 8 union select 9) t3,
 (select 0 i union select 1 union select 2 union select 3 union select 4 union select 5 union select 6 union select 7 union select 8 union select 9) t4) v
where selected_date between '2012-02-10' and '2012-02-15'

-未来的日期范围将近300年。

[根据UrvishAtSynapse的建议编辑进行更正。]