mysql 构造数字序列

with recursive tab as (
    select 1 as n
    union all 
    select n+1 from tab where n<100
)
select * from tab;