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
) a
WHERE
selected_date BETWEEN '2019-02-10'
AND now()
这个是在网上少有的最佳解决方案,如果有什么问题,可以留言指正