常用mysql语句

m.*,@r:=@r + 1 as rank from (SELECT @r:=0) r,userinfo as m order by m.id desc;

 

常用mysql语句

标签：