CREATE TABLE Dept(
Dno CHAR(2) PRIMARY KEY NOT NULL,
Dname CHAR(20),
Tele CHAR(9)
)engine = innodb;
CREATE TABLE Course(
Cno CHAR(2) PRIMARY KEY NOT NULL,
Subject CHAR(16) NOT NULL,
Time SMALLINT CHECK(Time>0),
Credit SMALLINT CHECK(Credit>0)
)engine = innodb;
CREATE TABLE Student(
Sno CHAR(9) PRIMARY KEY NOT NULL,
Name CHAR(8) NOT NULL,
Gen CHAR(2) CHECK(Gen IN('男','女')),
Birthday DATE,
Addr VARCHAR(20),
Dno CHAR(2),
#CONSTRAINT 'fk_1'
FOREIGN KEY (Dno) REFERENCES Dept(Dno)
)engine = innodb;
CREATE TABLE Class(
Classno CHAR(5) NOT NULL,
Num INT,
Monitor CHAR(9),
PRIMARY KEY(Classno),
FOREIGN KEY (Monitor) REFERENCES Student(Sno)
)engine = innodb;
CREATE TABLE Study(
Sno CHAR(9) NOT NULL,
Cno CHAR(2) NOT NULL,
Score DECIMAL(5,1),
PRIMARY KEY(Sno,Cno),
FOREIGN KEY(Sno) REFERENCES Student(Sno),
FOREIGN KEY (Cno) REFERENCES Course(Cno)
)engine = innodb;
uj5u.com熱心網友回復：
MySQL 去對應的版塊吧，這個我SQL Server 。另外你mysql的是版本是一樣的嗎，還有就是檢查下你的資料庫的組態檔，是不是選擇的模式不一樣uj5u.com熱心網友回復：
建哪個表的時候提示外鍵問題了？轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/106444.html
標籤：MySQL
上一篇：mysql
下一篇：新手求教 如何洗掉非整點時間資料