MySQL Performance: MySQL => update field with ranking

Members

Help

Home

Home » Performance » MySQL » update field with ranking

Show: Today's Messages :: Show Polls :: Message Navigator

update field with ranking [message #980]

Sat, 24 March 2007 08:06

carpii
Messages: 48
Registered: November 2006

Member

Hi, is there an efficient way to update a table with the rank of that row, given a specific order by

lets say i have

Table: users
userid int
score int
rank int

select * from users order by score DESC

I want to update the rank field, to the corresponding row number in the above query

Thanks

Report message to a moderator

[Message index]

Read Message update field with ranking
By: carpii on Sat, 24 March 2007 08:06

Re: update field with ranking
By: tanj on Mon, 26 March 2007 08:33

Re: update field with ranking
By: carpii on Tue, 27 March 2007 16:05

Previous Topic: ORDER BY slowing down query

Next Topic: Key Cache Behaviour

Goto Forum:

-=] Back to Top [=-

[ Generate printable PDF ] [ Syndicate this forum (XML) ] [

]

Current Time: Sun Jul 5 22:03:54 EDT 2009

Total time taken to generate the page: 0.00490 seconds

.:: Contact :: Home ::.

MySQL is a trademark of Sun Microsystems.
InnoDB is a trademark of Oracle Corp.

Percona Performance Forums are a service of Percona, Inc.
Not affiliated with Sun Microsystems or Oracle Corp.