From: Jangita
Date: September 23 2010 7:46am
Subject: RE: Swap data in columns
List-Archive: http://lists.mysql.com/mysql/223101
Message-Id: <!&!AAAAAAAAAAAYAAAAAAAAALyMZv6eUwNDpPRzpPZ7fpLCgAAAEAAAAJNnki6+EAlJqjDPWGUf/lYBAAAAAA==@jangita.com>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: 7bit

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