用mysql创建多个表格,表格单独创建成功,同时创建则失败.
虽然我用分号可以把前三个表创建成功,但是不能创建四五表。苦恼了一晚上了,救一下新人马楼吧!
CREATE TABLE Teacher(
TNo VARCHAR(5) PRIMARY KEY,
TN NVARCHAR(10),
Sex NCHAR(1),
Prof NVARCHAR(10),
Sal INT,
Comm INT,
Dept NVARCHAR(20)
)
CREATE TABLE Student(
SNo VARCHAR(5) PRIMARY KEY,
SN NVARCHAR(10),
Sex NCHAR(1),
Age INT,
Dept NVARCHAR(20)
)
CREATE TABLE Course(
CNo VARCHAR(5) PRIMARY KEY,
CN NVARCHAR(10) NOT NULL,
CT INT
)
CREATE TABLE SC(
SNo VARCHAR(5) NOT NULL CONSTRAINT Student_Fore FOREIGN KEY REFERENCES Student(SNo),
CNo VARCHAR(5) NOT NULL CONSTRAINT Course_Fore FOREIGN KEY REFERENCES Course(CNo),
Score INT CONSTRAINT SC_Chk CHECK(Score>=0 AND Score<=100),
PRIMARY KEY(SNo,CNo)
)
CREATE TABLE TC(
TNo VARCHAR(5) NOT NULL CONSTRAINT Teacher_Fore FOREIGN KEY REFERENCES Teacher (TNo),
CNo VARCHAR(5) NOT NULL CONSTRAINT Course_Fore FOREIGN KEY REFERENCES Course(CNo),
PRIMARY KEY(TNo,CNo)
)