Ah that's sheer genius!
Thanks muchly, I never figured in to being able to use SQL with it's own
"variables" so to speak - I'm sure I'll find more than one use for this new
ability!
Much appreciated Ed :)
----- Original Message -----
From: <emierzwa@stripped>
To: <admin@stripped>; <mysql@stripped>
Sent: Tuesday, February 10, 2004 3:19 PM
Subject: RE: A "current row updating" counter for a mass "Update" or
similar?
Sure, try this. I'm using 4.1.2 in case it matters.
set @n=0;
UPDATE Ranks_table
SET Rank= (select @n:=@n+1)
ORDER BY Score DESC;
Ed
