Simple MySQL solution
Using case:\n\nupdate salary \nset sex = case when sex = \'m\' then \'f\' else \'m\' end;\n\n\nIn case you get INVALID TESTCASE \'salary\' error. Ignore the err
Using case:\n```\nupdate salary \nset sex = case when sex = \'m\' then \'f\' else \'m\' end;\n```\n\nIn case you get INVALID TESTCASE \'salary\' error. Ignore the error and directly submit the solution. The system will ACCEPT.\n\nThere is some problem in the default testcase.\n\nPlease Upvote if you like the solution.
['MySQL']