Query to swap column values

Posted on May 4, 2006 by Alex

UPDATE table_name SET FIELD4 = (@tmp:=FIELD4), FIELD4 = FIELD1, FIELD1 =
@tmp;

Filed under: mysql | Tagged: | Leave a Comment »