查询以更新列中的两个数据(在两个之间交换) [英] Query to update the two datas(exchange between two ) in a column

问题描述

我有一个Emp表，其中以Empid，empname和gender作为列...并且我要更新gender ...当gender为"M"时. ...应像"F"一样更改，反之亦然...

你能帮忙吗?

非常紧急....

提前致谢....

Hi,

i am having Emp table which is having empid , empname and gender as columns...and i want to update gender...when gender is "M" means . ...should change like "F" vice versa......

can u help to do this??

very urgent....

advance thanks....

推荐答案

UPDATE [Emp] SET [gender]='Select' WHERE [gender]='Male'
UPDATE [Emp] SET [gender]='Male' WHERE [gender]='Female'
UPDATE [Emp] SET [gender]='Female' WHERE [gender]='Select'

这篇关于查询以更新列中的两个数据(在两个之间交换)的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！