List:General Discussion« Previous MessageNext Message »
From:Jangita Date:September 23 2010 7:46am
Subject:RE: Swap data in columns
View as plain text  
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

Thread
Swap data in columnsnixofortune22 Sep
  • RE: Swap data in columnsRolando Edwards22 Sep
    • Re: Swap data in columnsJohnny Withers22 Sep
      • Re: Swap data in columnsSteve Staples22 Sep
        • Re: Swap data in columnsJohnny Withers22 Sep
    • Re: Swap data in columnsEgor Shevtsov22 Sep
      • RE: Swap data in columnsRolando Edwards22 Sep
  • Re: Swap data in columnsKevin \(Gmail\)23 Sep
    • Re: Swap data in columnsnixofortune23 Sep
  • RE: Swap data in columnsJangita23 Sep
Re: Swap data in columnsnixofortune22 Sep