Change male to female and vice versa in MySQLsuppose 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' ) ;
Post a Comment