Powered by Blogger.

How to change male to female and vice versa in mysql


Change male to female and vice versa in MySQL

suppose you have a table "emp_gender" like

emp_idsex
1Male
2Female
3Male
100Female
101Male
102Male

update emp_gender set sex=IF( sex = 'male', 'female', 'male' ) ;

No comments