MYSQL 排名

u332744

I hava a table like this:

id,name,score,rank

1,anna,80,0

2,qera,65,0

6,kero,90,0

10,rosa,95,0

what I would like to do is to update the rank position.  I have this,

update mytable set rank= 1 where max(score);

update mytable set rank= 2 where max(score-1) ;

....

....

the result should be like this:

id,name,score,rank

1,anna,80,3

2,qera,65,4

6,kero,90,2

10,rosa,95,1