实现排名:
方法一:
SELECT t.*, @sort:= @sort+ 1 AS sort FROM (SELECT @sort:= 0) s, (SELECT * FROM table_name ORDER BY field DESC) AS t;
方法二:
SELECT t.*, @sort:= @sort+ 1 AS sort FROM (SELECT @sort:= 0) s, (SELECT * FROM table_name ORDER BY field DESC) AS t;