Hello,
I searched the manual but it seems like MySQL does not support ANSI SQL CHECK constraints. These are often used to check that rows inserted into tables meet specified criteria. For example table T created as follows CREATE TABLE T ( X INT, CHECK (X <= 10) ); has a check constraint so that if the user tried to insert a row with the following statement: INSERT INTO T VALUES (11); then the DBMS reports an error but if on the other hand the user enters INSERT INTO T VALUES (6); then 6 <= 10 so the insertion works fine. It would be nice if mysql supported this feature, but thanks for mysql. Have a nice day, Neil --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php