Re: A "current row updating" counter for a mass "Update" or similar?

2004-02-10 Thread Don Read
On 10-Feb-2004 [EMAIL PROTECTED] wrote: > Hi all, I'll just get straight to the problem (simplified): > > Say I have the following table/columns: > ID, Score, Rank > 1, 20, 0 > 2, 50, 0 > 3, 10, 0 > 4, 5, 0 > 5, 97, 0 > > Is it possible, in a single query (using sub-queries if necessary), > to g

Re: A "current row updating" counter for a mass "Update" or similar?

2004-02-10 Thread admin
gt; To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> 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 R

RE: A "current row updating" counter for a mass "Update" or similar?

2004-02-10 Thread emierzwa
bject: A "current row updating" counter for a mass "Update" or similar? Hi all, I'll just get straight to the problem (simplified): Say I have the following table/columns: ID, Score, Rank 1, 20, 0 2, 50, 0 3, 10, 0 4, 5, 0 5, 97, 0 Is it possible, in a single query (using

A "current row updating" counter for a mass "Update" or similar?

2004-02-09 Thread admin
Hi all, I'll just get straight to the problem (simplified): Say I have the following table/columns: ID, Score, Rank 1, 20, 0 2, 50, 0 3, 10, 0 4, 5, 0 5, 97, 0 Is it possible, in a single query (using sub-queries if necessary), to give all of these "ID's" the correct rank... ie if such a thing ex