CREATE TABLE Student
(Sno CHAR(9) PRIMARY KEY,
Sname CHAR(8)NOT NULL,
Ssex CHAR(2)CHECK(Ssex IN('男','女')),
Sage SMALLINT,
Sdept CHAR(20)
)
INSERT INTO Student(Sno,Sname,Ssex,Sdept,Sage)
VALUES('201215122','佟伊','M','IS',20);
SELECT * FROM Student
原因在于Student表中Ssex有约束条件,输入的内容不符合约束条件,将性别改成’男‘或者’女‘即可