创建外键
CREATE TABLE
userinfo
(
uid
INT(11) NOT NULL AUTO_INCREMENT,
uname
VARCHAR(50) NULL DEFAULT NULL,
department_id
INT(11) NULL DEFAULT NULL,
PRIMARY KEY (uid
),
INDEXfk_user_depart
(department_id
),
CONSTRAINTfk_user_depart
FOREIGN KEY (department_id
) REFERENCESdepartment
(did
)
)
COLLATE=’utf8_general_ci’
ENGINE=InnoDB修改表的外键约束
alter table userinfo
add constraint fk_user_depart foreign key (department_id) references department(did)删除外键
ALTER TABLE
userinfo
DROP FOREIGN KEYfk_user_depart
;
mySQL之外键创建
最新推荐文章于 2022-10-25 22:48:37 发布