Topic awaiting preservation: MySQL value swapping (Page 1 of 1)

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?

"If rabbits' feet are so lucky, then what happened to the rabbit?"

http://sqlcourse.com/update.html
What do you want to do with the record of id #2 ? Beware, you must not avoir some identical values in a primary ( unique ) ID.

marf: If it is like:

id | value1 | value2
2 | 34 | 34
3 | 45 | 45

and you want the values the other way round:

id | value1 | value2
2 | 45 | 45
3 | 34 | 34

it might be easier doing it by hand through PMA or (if you have too many entries) you could create a temporary table. If I have the wrong end of the stick then feel free to explain at greater length.

quote:

---

poi said:

Beware, you must not avoir some identical values in a primary ( unique ) ID.

---

The perils of multilingualism

___________________
Emps

The Emperor dot org | Justice for Pat Richard | FAQs: Emperor | Site Reviews | Reception Room

quote:

---

Emperor said:
The perils of multilingualism

---

oops, that combined with the perils of replying while I'm Out Of Mana in Dark Age Of Camelot

Um this is something done a bit easier with just changing the database column names instead of manually swapping all the values.

ALTER TABLE `databasename`.`table` CHANGE `col2` `col3` VARCHAR(200) NOT NULL

You'll probably have to do this 3 times col1 to temp col2 to col2 and temp to col2 but it's easier than swapping all the data.



.:[ Never resist a perfect moment ]:.

he wants to swap rows, not columns!

And I'd just swap the keys... but I'm lazy.