From: Kevin \(Gmail\) (kfoneill56gmail.com)
Date: Wed Sep 22 2010 - 18:03:04 CDT

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

update mydata set column1 = column2, column2 = column1
(works in sqlserver, can't try mysql at the moment)
You can select which rows by adding a where clause obviously.
I suppose that the field values are copied to a buffer which is the written
to the table at the end of the update (or row by row?)

----- Original Message -----
From: "nixofortune" <nixofortunegooglemail.com>
To: <mysqllists.mysql.com>
Sent: Wednesday, September 22, 2010 5:29 PM
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
>

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]