mysql生成日期列表
时间: 2023-07-05 09:07:50 浏览: 51
您可以使用以下SQL语句来生成一个日期列表:
```sql
SELECT DATE_ADD('2019-01-01', INTERVAL (t4*1000 + t3*100 + t2*10 + t1) DAY) AS date_list
FROM
(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) t4
WHERE DATE_ADD('2019-01-01', INTERVAL (t4*1000 + t3*100 + t2*10 + t1) DAY) <= '2019-12-31';
```
此SQL将生成从2019年1月1日到2019年12月31日之间的日期列表。您可以更改日期范围和日期格式以满足您的需求。