Chapter4, check
CREATE TABLE NamesAndAge
(
Names varchar(50),
Age int CHECK (Age >= 0)
);
INSERT INTO NamesAndAge(Names,Age) VALUES('Tom',22);
INSERT INTO NamesAndAge(Names,Age) VALUES('Mark',-30);
CHECK in this table doesn't work. I could insert +22 and -30...
Why?
My DB MySQL version: 5.0.22-Debian_0ubuntu6.06.3-log
Maybe my DB is badly configured?
|
