re ordering auto increment
Posted: Tue Nov 15, 2005 3:07 pm
Hey,
I have a table that has an auto_incremented column (not primary) which acts as a sort value for the information.
I want to know if i can "RE ORDER" the values of the column based on an update
e.g.
Kendall
I have a table that has an auto_incremented column (not primary) which acts as a sort value for the information.
I want to know if i can "RE ORDER" the values of the column based on an update
e.g.
can this be accomplishedif row 4 is 3 and row 7 is 7 and i update row 7's sort vaule to 3 it should re order the row values from row for go down
Kendall