ALTER TABLE yourtablename
ADD [CONSTRAINT 外键名] FOREIGN KEY [id] (index_col_name, ...)
REFERENCES tbl_name (index_col_name, ...)
[ON DELETE {CASCADE | SET NULL | NO ACTION | RESTRICT}]
[ON UPDATE {CASCADE | SET NULL | NO ACTION | RESTRICT}]
ALTER TABLE `child`
DROP FOREIGN KEY `fk_1`;
alter table child add constraint fk_1 foreign key (parent_id) references
parent(id) on update restrict on delete set null;
Mysql外键操作
最新推荐文章于 2024-05-05 16:17:03 发布