DDSA Solutions

627. Swap Salary

UnknownView on LeetCode
Database
Advertisement

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;
Advertisement
Was this solution helpful?