mysql常用指令
2016-03-18 本文已影响26人
hellowenqi
增加外键
建表的时候增加
CREATE TABLE Members (
Member_ID INT NOT NULL PRIMARY KEY AUTO_INCREMENT,
First_Name VARCHAR(30) NOT NULL,
Last_Name VARCHAR(30) NOT NULL,
Birthday DATE NOT NULL,
Gender ENUM('M', 'F') DEFAULT 'F'
);
CREATE TABLE Email (
Email VARCHAR(50),
Member_ID INT NOT NULL,
PRIMARY KEY (Email, Member_ID),
CONSTRAINT FOREIGN KEY (Member_ID) REFERENCES Members(Member_ID)
ON DELETE RESTRICT ON UPDATE CASCADE
);
建表后增加外键
ALTER TABLE Email add CONSTRAINT FOREIGN KEY(Member_ID) REFERENCES Members(Member_ID)
