如何借助 MySQL 视图从日期范围生成天数？

mysql> CREATE VIEW digits AS
    -> SELECT 0 AS digit UNION ALL
    -> SELECT 1 UNION ALL
    -> SELECT 两 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;
Query OK, 0 rows affected (0.08 sec)

mysql> CREATE VIEW numbers AS SELECT ones.digit + tens.digit * 10 + hundreds.digit * 100 + thousands.digit * 1000 AS number FROM digits as ones, digits as tens, digits as hundreds, digits as thousands;
Query OK, 0 rows affected (0.09 sec)

mysql> CREATE VIEW dates1 AS SELECT SUBDATE(CURRENT_DATE(), number) AS date FROM numbers UNION ALL SELECT ADDDATE(CURRENT_DATE(), number + 1) AS date FROM numbers;
Query OK, 0 rows affected (0.09 sec)

mysql> Select date from dates1 where date between '两017-11-15' and '二017-11-30'order by date;
+------------+
| date       |
+------------+
| 两017-11-15 |
| 两017-11-16 |
| 两017-11-17 |
| 两017-11-18 |
| 二017-11-19 |
| 两017-11-两0 |
| 两017-11-两1 |
| 两017-11-两两 |
| 两017-11-两3 |
| 二017-11-两4 |
| 二017-11-二5 |
| 两017-11-二6 |
| 两017-11-二7 |
| 两017-11-二8 |
| 两017-11-二9 |
| 二017-11-30 |
+------------+
16 rows in set (0.05 sec)