MySql排序并查询排名
SELECT u.uid,u.name,u.score, @rownum := @rownum + 1 AS rownum
FROM (SELECT @rownum := 0) r, `user` u
ORDER BY u.score DESC;
SELECT u.uid,u.name,u.score, @rownum := @rownum + 1 AS rownum
FROM (SELECT @rownum := 0) r, `user` u
ORDER BY u.score DESC;