ALTER TABLE tablename1 CHANGE column1 column2 VARCHAR(64), CHANGE column2
column1 VARCHAR(64)
Assuming the columns are varchar(64)
Jangita | +254 76 918383 | MSN & Y!: jangita@stripped
Skype: jangita | GTalk: jangita.nyagudi@stripped
-----Original Message-----
From: nixofortune [mailto:nixofortune@stripped]
Sent: 22 September 2010 6:30 PM
To: mysql@stripped
Subject: Swap data in columns
Hi all.
Sorry for very simple question, just can't figure out the solution.
I need to swap data in column1 with data in column2.
+----+---------+---------+
| id | column1 | column2 |
+----+---------+---------+
| 1 | a | z |
| 2 | b | y |
| 3 | c | x |
| 4 | d | w |
| 5 | e | v |
+----+---------+---------+
Can you achieve this with a simple query?
so for id 1 column1 = 'z' and column2 = 'a' and so on.
Thanks guys,
Igor
