2 mysql solution
You can follow any of the two methods\n\nupdate salary set sex = if(sex=\'m\',\'f\',\'m\');\n\n\n\nupdate salary\nset sex = \ncase sex when \'m\' then \'f\' els
You can follow any of the two methods\n```\nupdate salary set sex = if(sex=\'m\',\'f\',\'m\');\n```\n\n```\nupdate salary\nset sex = \ncase sex when \'m\' then \'f\' else \'m\'\nend;\n\n\n```
['MySQL']