查看“常用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))
[[分类:Develop]]
[[分类:DB]]