Using MySQL 4.02 on SuSE Linux 7.3 The MySQL docs at http://www.mysql.com/doc/C/R/CREATE_TABLE.html state that CHECK (expr) is not parsed for table types other that innodb. But when the table type is innodb I assume it is parsed. I'd like to retain the CHECK parameters in my CREATE scripts, but can't seem to get past the parser. Eample: CREATE TABLE IF NOT EXISTS apptype ( aptype_id INT UNSIGNED NOT NULL AUTO_INCREMENT, PRIMARY KEY (aptype_id), max_sched VARCHAR(1), CHECK (max_sched REGEXP "[0-9]") ) TYPE=Innodb; This generates: ERROR 1064: You have an error in your SQL syntax near '(max_sched REGEXP "[0-9]" Is there a syntax that will pass the parser? Or should the CHECK option in the CREATE TABLE documentation be removed completely? Best Regards, Larry Irwin CCA Medical sql, query
--------------------------------------------------------------------- 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
