List:General Discussion« Previous MessageNext Message »
From:nixofortune Date:September 22 2010 4:29pm
Subject:Swap data in columns
View as plain text  
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