MySQL swap 2 rows values

1
2
3
4
5
6
7
8
9
10
SET @A_ID := 1;
SET @B_ID := 2;

-- swap logic on `column_name` column in `table_name` table

SET @A_VALUE := (SELECT `column_name` FROM `table_name` WHERE `id` = @A_ID LIMIT 1);
SET @B_VALUE := (SELECT `column_name` FROM `table_name` WHERE `id` = @B_ID LIMIT 1);

UPDATE `table_name` SET `column_name` = @B_VALUE WHERE `id` = @A_ID;
UPDATE `table_name` SET `column_name` = @A_VALUE WHERE `id` = @B_ID;