【数据库笔记】MySQL生成连续整数序列

MySQL8

with recursive t(n) as (

select 1

union all

select n+1 from t where n<5

)

select * from t;

--计算1到100的累加的结果。
WITH RECURSIVE t(n) AS (
    VALUES (1)
  UNION ALL
    SELECT n+1 FROM t WHERE n < 100
)
SELECT sum(n) FROM t;

输出：5050
Oracle

select level n

from dual connect by level<=5;

n
1
2
3
4
5