SELECT aaa,(@rowNum:=@rowNum+1) AS rowNo
FROM tb_bbb,
(SELECT (@rowNum :=0) ) b
ORDER BY tb_bbb.liushuihao DESC
mysql 实现行号的方法——如何获取当前记录所在行号
最新推荐文章于 2024-12-29 16:05:07 发布
SELECT aaa,(@rowNum:=@rowNum+1) AS rowNo
FROM tb_bbb,
(SELECT (@rowNum :=0) ) b
ORDER BY tb_bbb.liushuihao DESC