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