leetcode 627 變更性別

Carl_ZhangJH / 2023-05-10 / 原文

 

update `Salary` set sex = if(sex = 'f','m','f')

 

update Salary set sex=(
    case when sex='m' then 'f'
    else 'm'
    end
)