recursive 使用示例

recursive 使用示例

mysql> select version();
+-----------+
| version() |
+-----------+
| 8.0.33    |
+-----------+
1 row in set (0.00 sec)

mysql> with recursive t(n) as (
    -> select 1 as n 
    -> union all 
    -> select n+1 from t where n <10
    -> )
    -> select * from t;
+------+
| n    |
+------+
|    1 |
|    2 |
|    3 |
|    4 |
|    5 |
|    6 |
|    7 |
|    8 |
|    9 |
|   10 |
+------+
10 rows in set (0.00 sec)