MySQL Forums
Forum List  »  Knowledge Base

Constraint help
Posted by: T.J. Eakle
Date: October 03, 2009 02:29PM

Hey there,

I have a user_id and primary_ind column. I would like as many of the same user id's to be able to be inserted into the table, but only one of them would be allowed to have a 'Y' as the primary ind. Can someone help me with that constraint script?

Thanks,

T.J.

Options: ReplyQuote


Subject
Views
Written By
Posted
Constraint help
2688
October 03, 2009 02:29PM
1355
October 05, 2009 05:16PM


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.