MySQL UPDATE incremental number

[Anon]

Hi,

Quick question, I want an SQL query that will update a set of rows with an incremental number..

ie.

Current Table
Row:ColumValue
1:0
2:0
3:0
4:0

Updated table
Row:ColumValue
1:1
2:2
3:3
4:4

Something along the lines of...

UPDATE table SET ColumnValue = MAX(ColumnValue) + 1

But GROUP functions arn't allowed in an statement.. Any ideas...

[Anon]

Try an autonumeric field. When creating the table, define it like this:

auto int(11) NOT NULL AUTO_INCREMENT PRIMARY KEY

Then, the number will increase one for each row. Just insert a NULL value to it.

fLIPIS

[Anon]

Nah, that's no use, the table already exists, and needs to be updated.

Also, the column is not unique throughout the table....

Oh, well... I've updated the table by hand now... MySQL really needs sub-query support it would be easy then.... 🙁

Cheers anyway,

Vex