/ Published in: MySQL
Expand |
Embed | Plain Text
UPDATE mytable SET columnA=(@temp:=columnA), columnA = columnB, columnB = @temp;
You need to login to post a comment.
fugue on 10/05/10
2 people have marked this snippet as a favorite
UPDATE mytable SET columnA=(@temp:=columnA), columnA = columnB, columnB = @temp;
You need to login to post a comment.