SELECT (@i:=@i+1) as pm , `key`, `name`,total_integration FROM `user` ,
(SELECT @i:=0) AS i ORDER BY total_integration DESC
Mysql (把查询出来的数据添加序号)
最新推荐文章于 2024-09-07 17:46:09 发布
SELECT (@i:=@i+1) as pm , `key`, `name`,total_integration FROM `user` ,
(SELECT @i:=0) AS i ORDER BY total_integration DESC