DDSA Solutions

627. Swap Salary

UnknownView on LeetCode
Database

Problem Overview

SQL UPDATE using CASE or XOR trick to swap 'm' and 'f' values.

Intuition

SQL UPDATE using CASE or XOR trick to swap 'm' and 'f' values.

Algorithm

  1. 1UPDATE Salary SET sex = CASE WHEN sex = "m" THEN "f" ELSE "m" END.
  2. 2Or: UPDATE Salary SET sex = IF(sex="m", "f", "m").

Common Pitfalls

  • •Single UPDATE statement with CASE is most efficient � no need to create temp values.
627.sql
MySQL
UPDATE Salary
SET sex = CASE WHEN sex = 'm' THEN  'f' ELSE  'm' END;
Was this solution helpful?

Related Problems