查出排名
set @row_num = 0;(select *,@row_num:=@row_num+1 as n from activity_items order by num DESC limit 0,10);
查出排名
set @row_num = 0;(select *,@row_num:=@row_num+1 as n from activity_items order by num DESC limit 0,10);
转载于:https://www.cnblogs.com/samxiong/p/10979506.html