学习知识要善于思考，思考，再思考！今天24分享网小编就给大家带来《如何从 MySQL 中的日期范围生成天数？》，以下内容主要包含等知识点，如果你正在学习或准备学习数据库，就都不要错过本文啦~让我们一起来看看吧，能帮助到你就更好了！

可以借助以下使用 adddate() 函数的查询来完成，我们生成“2016-12-15”和“2016-12-31”之间的天数 -

mysql> select * from     -> (select adddate('1970-01-01',t4*10000 + t3*1000 + t2*100 + t1*10 + t0) gen_date from     -> (select 0 t0 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 t1 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 t2 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 t3 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 t4 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 gen_date between '2016-12-15' and '2016-12-31'     -> ; +------------+ | gen_date   | +------------+ | 2016-12-15 | | 2016-12-16 | | 2016-12-17 | | 2016-12-18 | | 2016-12-19 | | 2016-12-20 | | 2016-12-21 | | 2016-12-22 | | 2016-12-23 | | 2016-12-24 | | 2016-12-25 | | 2016-12-26 | | 2016-12-27 | | 2016-12-28 | | 2016-12-29 | | 2016-12-30 | | 2016-12-31 | +------------+ 17 rows in set (0.30 sec)

好了，本文到此结束，带大家了解了《如何从 MySQL 中的日期范围生成天数？》，希望本文对你有所帮助！关注the24.cn，给大家分享更多数据库知识！