mysql外键约束

最新推荐文章于 2024-08-04 18:39:47 发布

l1306395862

最新推荐文章于 2024-08-04 18:39:47 发布

阅读量176

点赞数

本文链接：https://blog.csdn.net/l1306395862/article/details/107248054

版权

一对多在多的一边添加外键

CREATE TABLE account(
	id INT PRIMARY KEY AUTO_INCREMENT,
	username VARCHAR(20),
	PASSWORD VARCHAR(20),
	dep_id INT,
	CONSTRAINT account_dep_fk FOREIGN KEY (dep_id) REFERENCES department(id);
);

删除外键语句

ALTER table account DROP  FOREIGN KEY account_dep_fk;

添加外键语句

ALTER table account ADD CONSTRAINT account_dep_fk FOREIGN KEY (dep_id) REFERENCES department(id)

设置级联操作

--级联更新
ALTER table account ADD CONSTRAINT account_dep_fk FOREIGN KEY (dep_id) REFERENCES department(id) ON UPDATE CASCADE;
--级联删除
ALTER TABLE account ADD CONSTRAINT account_dep_fk FOREIGN KEY (dep_id) REFERENCES department(id) ON UPDATE CASCADE ON DELETE CASCADE;