TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
C# Corner
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Update Male TO Female and Female To Male with single query
Satyapriya Nayak
Apr 09, 2013
44.6
k
0
2
facebook
twitter
linkedIn
Reddit
WhatsApp
Email
Bookmark
Update Male TO Female and Female To Male with single query
UPDATE employee
SET
gender = CASE gender WHEN 'male' THEN 'female' WHEN 'female' THEN 'male'
ELSE gender
END
Update Male TO Female and Female To Male with single query
Next Recommended Reading
Insert multiple rows in single query