不使用存储过程，不使用临时表，不使用循环在Mysql中获取一个时间段的全部日期

紫竹修

于 2020-02-15 21:21:02 发布

阅读量713

点赞数

分类专栏： mysql 文章标签： mysql sql 数据库

本文链接：https://blog.youkuaiyun.com/qq_27840695/article/details/104334879

版权

mysql 专栏收录该内容

7 篇文章

订阅专栏

select a.Date 
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
) a
where a.Date between '2017-11-10' and '2017-11-15'

输出为：

Date
----------
2017-11-15
2017-11-14
2017-11-13
2017-11-12
2017-11-11
2017-11-10