List:General Discussion« Previous MessageNext Message »
From:Martijn Tonies Date:December 15 2005 9:05am
Subject:Re: check a table column
View as plain text  

> 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

Thread
check a table columnwangxu15 Dec
  • Re: check a table columnMartijn Tonies15 Dec