SELECT
@rownum:=@rownum+1 AS rownum
FROM t1,
(SELECT @rownum:=0) t2
//通过一个初始值为0的变量@rownum:依次递增1来实现行号
当然也可以实现分组
SELECT
CEILING((@rownum:=@rownum+1)/6) AS levl
FROM
t1,
(SELECT @rownum:=0) t2
SELECT
@rownum:=@rownum+1 AS rownum
FROM t1,
(SELECT @rownum:=0) t2
//通过一个初始值为0的变量@rownum:依次递增1来实现行号
当然也可以实现分组
SELECT
CEILING((@rownum:=@rownum+1)/6) AS levl
FROM
t1,
(SELECT @rownum:=0) t2
转载于:https://my.oschina.net/lhplj/blog/192826