常用SQL

MySQL

生成连续数字

with recursive seq(no) as(
    select   1  no
    union all
    select   no+1  no
    from     seq
    where    no < 100
)
select   no
from     seq
;

固定长度数字

substr(concat('00000', floor(rand() * 1000000)), -6)

近一百天内时间

select subdate(now(), cast(rand() * 100 as int))