List:General Discussion« Previous MessageNext Message »
From:<admin Date:February 10 2004 3:36pm
Subject:Re: A "current row updating" counter for a mass "Update" or similar?
View as plain text  
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



Thread
A "current row updating" counter for a mass "Update" or similar?admin10 Feb
  • Re: A "current row updating" counter for a mass "Update" or similar?Don Read10 Feb
RE: A "current row updating" counter for a mass "Update" or similar?emierzwa10 Feb
  • Re: A "current row updating" counter for a mass "Update" or similar?admin10 Feb