MySLQ排序后标记排行

查询排行及所有(表名.*)

set @rownum=0;

SELECT @rownum:=@rownum+1 AS top, customer.*

FROM  customer

SELECT @rownum:=@rownum+1 AS top, customer.*

FROM (SELECT @rownum:=0) r, customer ORDER BY customer.this_month_cost DESC

1和2的结果：

查询排行及id(表名.id)

SELECT @rownum:=@rownum+1 AS top, customer.id

FROM (SELECT @rownum:=0) r, customer ORDER BY customer.this_month_cost DESC

结果：

排序后更新原表的排行：

UPDATE `customer` c,

 (

    SELECT

        @rownum :=@rownum + 1 AS rownum,

        customer.id

    FROM

        (SELECT @rownum := 0) r,

        customer

    ORDER BY

        customer.this_month_cost DESC

) a

SET c.top = a.rownum

WHERE

    c.id = a.id

-----------------------------------条条大路通罗马------------------------------------------

巴特西

MySLQ排序后标记排行

最新文章

热门文章