need help with updating field in table

[intercampus2]

What is the command to use in case i would like to change the value of one field on a mysql table by number on descending order, i mean, i have a field call "number" on the table called "data" how can i set the value of "number" to:

1
2
3
4
each time the script is executed

thanx

[yelvington]

You say "descending order" then show ascending order in your example. What are you trying to do that is not adequately dealt with by declaring the column to have the AUTO_INCREMENT attribute in the table definition?

[tsinka]

Hi,

if that field isn't an auto_incremet field in your table and you want to increment it by 1 you can do something like

UPDATE data SET number=number+1 WHERE ...

Thomas