Re: check a table column

> 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 pa

check a table column

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