参考:
https://blog.csdn.net/gao763024185/article/details/79638052
SET @rank:=0;
SELECT @rank:=@rank + 1, id
FROM (
SELECT *
FROM tb1) AS a ;
# SELECT @rank:= 0 放在FROM是为了初始化为0,替代了SET @rank:=0;
SELECT @rank:=@rank + 1, id
FROM (
SELECT *
FROM tb1) AS a,(
SELECT @rank:= 0) AS b;
# 每行得到的值都是相同的,是因为每次select都重新给@rank赋值为0了
SELECT @rank:=0, @rank:=@rank + 1, id
FROM (
SELECT *
FROM tb1) AS a ;