MySQL and CHECK

[wolfmah]

Is it possible in MySQL to put a CHECK in your CREATE TABLE sentence? I have try this below but it doesn't work at all.

CREATE TABLE test(
id TINYINT UNSIGNED NOT NULL ,
PRIMARY KEY ( id ) ,
UNIQUE UC_id( id ) ,
CHECK (
id > 33
)
);

http://www.wolfmahheaven.net

 

[swampBoogie]

Check constraints in Mysql are bogus. They allow the syntax but they don't enforce the constraint. No alternative but doing the checking yourself.

A primary key constraint implies uniqueness, so having both is redundant.