SELECT
obj.id,obj.username,obj.blognum, @rownum := @rownum + 1 AS rownum
FROM
(
SELECT id, username,blognum FROM users ORDER BY blognum DESC
) AS obj,
(SELECT @rownum := 0) r
输出结果
SELECT
obj.id,obj.username,obj.blognum, @rownum := @rownum + 1 AS rownum
FROM
(
SELECT id, username,blognum FROM users ORDER BY blognum DESC
) AS obj,
(SELECT @rownum := 0) r
输出结果