Mysql外键操作

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;