Dear subscribers, MySQL seems to support the CHECK() clausole in the implementation of CREATE TABLE statement, but MySQL (Ver 11.15 Distrib 3.23.39, for pc-linux-gnu) returns a syntax error on such a command. For example:
mysql> CREATE TABLE example (var INTEGER, CHECK(var BETWEEN 0 AND 1)); ERROR 1064: You have an error in your SQL syntax near '(var BETWEEN 0 AND 1))' at line 1 If I remove the CHECK clausole, the sql statement works: mysql> CREATE TABLE example (var INTEGER); Query OK, 0 rows affected (0.01 sec) Can anyone suggest me how to correctly use the CHECK clausole in MySQL (even if for compatibility issues with other sql databases) ? Thanks in advance for your suggestions. Achille --------------------------------------------------------------------- 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