查询竞技场 排名前一百的玩家(交流群1161142301)
SET @ranking=0; SELECT user_id, score, @ranking:=@ranking+1 AS ranking FROM arena ORDER BY score DESC limit 100;
查询竞技场 排名前一百的玩家(交流群1161142301)
SET @ranking=0; SELECT user_id, score, @ranking:=@ranking+1 AS ranking FROM arena ORDER BY score DESC limit 100;