subject:"check a table column"

Re: check a table column

2005-12-15 Thread Martijn Tonies

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

check a table column

2005-12-14 Thread wangxu

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);