Hi Kevin, It works in mysql but not exactly as I need. In my case it copied content of column2 into column1. So, not exactly what I intended to achieve. Thanks. Igor
update mydata set column1 = column2, column2 = column1 On Thu, Sep 23, 2010 at 12:03 AM, Kevin (Gmail) <kfoneil...@gmail.com>wrote: > 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" < > nixofort...@googlemail.com> > > To: <mysql@lists.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 >> >> >