MySQL Forums
Forum List  »  Newbie

TRIGGER BEFORE/AFTER INSERT
Posted by: j j
Date: August 28, 2009 12:09AM

I created a table that stores the gender of a person. Before or after inserting (which ever is best) I would like to verify that the sex entered is either (male or female) case insensitive.

Firstly is this the best way to store gender, secondly how would I go about creating a trigger. Thankyou

Options: ReplyQuote


Subject
Written By
Posted
TRIGGER BEFORE/AFTER INSERT
j j
August 28, 2009 12:09AM
August 28, 2009 03:54AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.