MySQL Forums
Forum List  »  General

CHECK clause
Posted by: Stella Wang
Date: January 31, 2005 04:34PM

I'm using MySQL 4.1.9 and I have a table where I want to use the CHECK clause to maintain an integrity constraint on the table. More specifically, the constraint that I want to enforce is that there are these three colomns in the table, and for any one record/row, exactly ONE of these columns should be non-empty, the other two should be either NULL or '' (empty string). When I read in the manual, very disappointingly, it said "The CHECK clause is parsed but ignored by all storage engines." And I've
been trying really hard to find other ways to get around this limitation, but haven't had any success yet...

So, I am just wondering, will the CHECK clause be supported in some future version/release? Or, is it not going to be supported ever?

Thanks a lot!

Options: ReplyQuote


Subject
Written By
Posted
CHECK clause
January 31, 2005 04:34PM


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.