MySQL Forums
Forum List  »  MySQL Administrator

Status column
Posted by: Rochelle Caguioa
Date: January 12, 2010 02:34AM


I have a column with enum type with possible values of only 'active' and 'inactive'. Is there a way, in the database level, to ensure that only one row is set to 'active'? Probably, like some constraint or uniqueness directive to only a specific value. In this case, the 'active' value.

Thanks in advance.

Options: ReplyQuote

Written By
Status column
January 12, 2010 02:34AM

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.