window.ENTITIES={'/api/snippets/sql/mysql%20swap%202%20rows%20values':[{"result":true,"message":null,"batch":{"type":"sql","name":"mysql swap 2 rows values","items":[{"id":"pJAKqD","type":"sql","name":"MySQL swap 2 rows values","content":"SET @A_ID := 1;\nSET @B_ID := 2;\n\n-- swap logic on `column_name` column in `table_name` table\n\nSET @A_VALUE := (SELECT `column_name` FROM `table_name` WHERE `id` = @A_ID LIMIT 1);\nSET @B_VALUE := (SELECT `column_name` FROM `table_name` WHERE `id` = @B_ID LIMIT 1);\n\nUPDATE `table_name` SET `column_name` = @B_VALUE WHERE `id` = @A_ID;\nUPDATE `table_name` SET `column_name` = @A_VALUE WHERE `id` = @B_ID;","source":"","author":{"id":"dDYwko","name":"Nicola-Melendez","avatar":"1629141845109__dDYwko__w40px_h40px.jpg","points":375,"role":"BASIC"},"creationTime":1649067676000,"updateTime":null,"removalTime":null}]}}]};