MYSQL 排名

蓝寅舞九天

if your table is named test1 ,then
update test1 x
inner join ( SELECT
a.id,count(*) as rank from  test1   a
inner join  test1 b on a.score<=b.score
group by  a.id) y
on x.id =y.id
set x.rank =y.rank