In the customer's table,
change Gender - Male to Female & Female to male

ALTER TABLE customers ADD gender VARCHAR(10);



UPDATE customers
SET gender=(CASE WHEN gender='male' THEN 'female'
WHEN gender='female' THEN 'male'
END)



SELECT * FROM customers

свернуть