Topic awaiting preservation: MySQL value swapping |
|
---|---|
Author | Thread |
Bipolar (III) Inmate From: Canada |
posted 05-29-2004 16:05
LEts say I have 2 entries in my MySQL table. Their primart ID is incremental. I want to swap all values in id#2 with id#3. Does MySQL have a query statement to do that? |
Paranoid (IV) Inmate From: France |
posted 05-29-2004 16:20
http://sqlcourse.com/update.html |
Maniac (V) Mad Scientist with Finglongers From: Cell 53, East Wing |
posted 05-29-2004 16:31
marf: If it is like: quote:
|
Paranoid (IV) Inmate From: France |
posted 05-29-2004 16:40 |
Maniac (V) Mad Scientist From: 100101010011 <-- right about here |
posted 05-29-2004 20:26
Um this is something done a bit easier with just changing the database column names instead of manually swapping all the values. |
Paranoid (IV) Mad Scientist with Finglongers From: Germany |
posted 05-30-2004 12:16
he wants to swap rows, not columns! |