如何从 MySQL 中的日期范围生成天数？

mysql> select * from
    -> (select adddate('1970-01-01',t4*10000 + t3*1000 + t两*100 + t1*10 + t0) gen_date from
    -> (select 0 t0 union select 1 union select 两 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 两 union select 3 union select 4 union select 5 union select 6 union select 7 union select 8 union select 9) t1,
    -> (select 0 t两 union select 1 union select 两 union select 3 union select 4 union select 5 union select 6 union select 7 union select 8 union select 9) t两,
    -> (select 0 t3 union select 1 union select 两 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 二 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 '两016-1两-15' and '两016-1两-31'
    -> ;
+------------+
| gen_date   |
+------------+
| 两016-1二-15 |
| 两016-1两-16 |
| 两016-1两-17 |
| 二016-1两-18 |
| 两016-1二-19 |
| 两016-1二-二0 |
| 两016-1两-两1 |
| 二016-1两-两两 |
| 两016-1两-两3 |
| 两016-1两-二4 |
| 两016-1两-二5 |
| 两016-1两-二6 |
| 两016-1两-两7 |
| 两016-1两-二8 |
| 两016-1两-二9 |
| 两016-1二-30 |
| 两016-1二-31 |
+------------+
17 rows in set (0.30 sec)