update Salary set sex =(case sex when 'm' then 'f' else 'm' end)
update salary set sex = char(ascii('m') + ascii('f') - ascii(sex));
用sql交换两条数据中某个字段的值
最新推荐文章于 2024-07-06 00:33:08 发布
update Salary set sex =(case sex when 'm' then 'f' else 'm' end)
update salary set sex = char(ascii('m') + ascii('f') - ascii(sex));