mysql级联删除外键约束_mysql增加外键级联删除示例

增加外键级联删除：

ALTER TABLE `extends`

ADD CONSTRAINT `extends_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`)

ON DELETE CASCADE ON UPDATE NO ACTION;

删除外键约束：

ALTER TABLE `extends` DROP FOREIGN KEY `extends_ibfk_1`;

查看完整建表(show create table `extends`)：

CREATE TABLE `extends` (

`id` int(11) NOT NULL AUTO_INCREMENT,

`user_id` int(11) NOT NULL,

`remark` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,

PRIMARY KEY (`id`),

KEY `user_id` (`user_id`),

CONSTRAINT `extends_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`)

ON DELETE CASCADE ON UPDATE NO ACTION

) ENGINE=InnoDB DEFAULT CHARSET=utf8