HI WELCOME TO KANSIRIS

Update Male TO Female and Female To Male with single query

Leave a Comment
UPDATE    employee
SET              
gender = CASE gender WHEN 'male' THEN 'female' WHEN 'female' THEN 'male'
ELSE gender 
END

0 comments:

Post a Comment

Note: only a member of this blog may post a comment.