SELECT
t1.*,@rank :=@rank + 1 AS pm
FROM
(
SELECT
*
FROM
userlog
ORDER BY
ys
) AS t1,
(SELECT @rank := 0) AS t2
这样就可以指定字段ys来进行排名了,结果如下
如果有什么问题及不懂的可以于关注公众号 回复999加我微信交流下
SELECT
t1.*,@rank :=@rank + 1 AS pm
FROM
(
SELECT
*
FROM
userlog
ORDER BY
ys
) AS t1,
(SELECT @rank := 0) AS t2
这样就可以指定字段ys来进行排名了,结果如下
如果有什么问题及不懂的可以于关注公众号 回复999加我微信交流下