Search Knowledge Base

Home » SQL » Swapping column value MySQL, Oracle

Swapping column value MySQL, Oracle

Posted by MrZam at 2:56 PM

Share this

Problem:

UPDATE tbl_swap SET x=y, y=x;

Solution:

UPDATE tbl_swap s1, tbl_swap s2
SET s1.x=s1.y, s1.y=s2.x 
WHERE s1.id=s2.id;