swapping two rows?

[tonyw]

hi,

just wondering what's the prefered way to swap two rows around? I currently order-by the auto increment value, which is fine in itself. But am i able to actually manipulate those auto-inc'd values in existing rows? eg swap them? I guess if not i should create a new value 'position' which mirrors the auto-inc value but can be swapped across rows, at will?

hmmm, any thoughts?

thanks

[Plasma]

Shouldnt touch the primary key / auto increment.

If you rely on a specific order for columns, create a new field such as 'position' and order by that.

[Roger_Ramjet]

Surprisingly, you can update an autoinc column in mysql. I'm more used to dbs that will not let you alter the values of identity columns. Very dodgy idea that, can't see why anyone would design a db like that - defeat the whole purpose of an identity column.