mysql排名语句 SELECT *,@rownum:=@rownum + 1 AS rank FROM (SELECT * FROM 表格 ORDER BY 字段 ASC) AS a,(SELECT @rownum:=0) AS b;