MySQL实现排行榜功能
select @row_no:=@row_no+1 as row_no,user_score,user_name,user_id
from ( select @rowno:=0, user_score, user_id, user_name
from user_score
ORDER BY user_score desc) user_score_temp
MySQL实现排行榜功能
select @row_no:=@row_no+1 as row_no,user_score,user_name,user_id
from ( select @rowno:=0, user_score, user_id, user_name
from user_score
ORDER BY user_score desc) user_score_temp