Hi. First of all, do all of us, including yourself, a favor and upgrade to 4.0.9 (or 4.0.10 which should come out this week). Reporting problems against a 7 months old alpha version is not very, well, productive, if the current release is gamma quality.
On Mon 2003-02-03 at 10:04:58 +0100, [EMAIL PROTECTED] wrote: > > I have a create table command in which the check statement does > not seem to do anything. I know it was just there for compatibility > in older mySQL versions, but I thought it should be working in > version 4.0.2. Isn't it? Where did you get that from? The only 4.0 change entry mentioned CHECK is for 4.0.6 (which you don't have) and explictly tells that it is still not implemented: http://www.mysql.com/doc/en/News-4.0.6.html And the CREATE TABLE section explains the same: http://www.mysql.com/doc/en/CREATE_TABLE.html Regards, Benjamin. -- [EMAIL PROTECTED] --------------------------------------------------------------------- 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