UPDATE mdl_dz_user as u1 INNER JOIN (SELECT id,point,@i :=@i+1 as r from mdl_dz_user INNER JOIN (SELECT @i:=0) b ORDER BY point desc) as u2 set u1.rank2=u2.r where u1.id = u2.id;
按照point 字段来排序 并给rank2字段赋值
UPDATE mdl_dz_user as u1 INNER JOIN (SELECT id,point,@i :=@i+1 as r from mdl_dz_user INNER JOIN (SELECT @i:=0) b ORDER BY point desc) as u2 set u1.rank2=u2.r where u1.id = u2.id;
按照point 字段来排序 并给rank2字段赋值