From: Martijn Tonies
Date: December 15 2005 9:05am
Subject: Re: check a table column
List-Archive: http://lists.mysql.com/mysql/192860
Message-Id: <013301c60156$a87c6e20$cd02a8c0@martijnws>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="gb2312"
Content-Transfer-Encoding: 7bit



> I create a table using the follow statement:
>
>    CREATE TABLE test_check(NO_W_ID int ,NO_D_ID int,MM int,CT int,CHECK(MM
> 3));
>
> But server allow a insert statement as follow,why?
>
>    insert into test_check values(1,1,1,1);

Because MySQL does not support CHECK constraints.

Yes, it parses them, but no constraints are created.

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Server
Upscene Productions
http://www.upscene.com
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com