生成自增序列

1.不借助中间表生成自增序列

-- 自定义变量，生成自增序列
SELECT @row := @row + 1 AS row FROM
(select 0 union all select 1 union all select 2 union all select 3 union all select 4 union all select 5 union all select 6 union all select 7 union all select 8 union all select 9 ) a1,
(select 0 union all select 1 union all select 2 union all select 3 union all select 4 union all select 5 union all select 6 union all select 7 union all select 8 union all select 9) a2,
(select 0 union all select 1 union all select 2 union all select 3 union all select 4 union all select 5 union all select 6 union all select 7 union all select 8 union all select 9) a3,
(SELECT @row:=0) b1
-- 表a1,a2,a3会按照笛卡尔积生成10*10*10行

2.借助中间表生成自增序列