Solution of swap salary problem
Approach\nSolved using SQL\n- Changing records in a table is done using an UPDATE query\n- The IF() function evaluates a logical expression; if it is true, the 
# Approach\nSolved using SQL\n- Changing records in a table is done using an `UPDATE` query\n- The `IF()` function evaluates a logical expression; if it is true, the value $$VALUE 1$$ is entered in the field, otherwise the value $$VALUE 2$$ is entered.\n\n# Code\n```\nUPDATE Salary\nSET sex = if(sex = \'m\', \'f\', \'m\');\n\n```
['Database', 'MySQL']