I have created a table 'n i need to place constraints on the columns such taht the combination of two columns should be unique.
there is another combination of columns such that
if account_name is populated either account_pop3 or account_imap shud be populated...the other one can be null.
plz help me...
thanx a lot for that but i needed to know the syntax for the statement...i.e. the individual columns may've duplicate info but the combination of the columns needa be unique...so if u cud plz help me with the syntax.... 'n the second combination is not at all possible?
Originally posted by r937
the first requirement is really straightforward, it's just a unique constraint on two columns
the second requirement is a check constraint, which i don't believe mysql supports