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
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
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
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