Leetcode Problem 627. Swap Salary

627. Swap Salary

Leetcode Solutions

Begin with the UPDATE statement to indicate that we are modifying the Salary table.
Use the SET clause to specify the column we are updating, which is the sex column.
Inside the SET clause, use a CASE statement to evaluate the current value of the sex column.
For each row, check the value of sex using the WHEN clause.
If the value is 'm', then use THEN to set it to 'f'.
If the value is not 'm', it must be 'f', so use ELSE to set it to 'm'.
End the CASE statement with END to complete the conditional logic.
Execute the query to update the table with the swapped values.

erDiagram
    Salary {
        int id PK
        varchar name
        ENUM sex
        int salary
    }

Programming Language

Purpose:

General Question

Debug My Code

image/screenshot of info(optional)

Full Screen