ON DELETE CASCADE update a parent row aforeign key constraint fails

 

DROP TABLE IF EXISTS `triallist`;
CREATE TABLE `triallist` (
  `triallist_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Triallist ID',
  `customer_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Customer ID',
  `shared` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Sharing flag (0 or 1)',
  `sharing_code` varchar(32) DEFAULT NULL COMMENT 'Sharing encrypted code',
  `updated_at` timestamp NULL DEFAULT NULL COMMENT 'Last updated date',
  PRIMARY KEY (`triallist_id`),
  UNIQUE KEY `TRIALLIST_CUSTOMER_ID` (`customer_id`),
  KEY `TRIALLIST_SHARED` (`shared`),
  CONSTRAINT `TRIALLIST_CUSTOMER_ID_CUSTOMER_ENTITY_ENTITY_ID` FOREIGN KEY (`customer_id`) REFERENCES `customer_entity` (`entity_id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=180 DEFAULT CHARSET=utf8 COMMENT='Triallist main Table';
无法删除表

ON DELETE CASCADE

为表order_items(Product_id)添加一个bai外键duOrder_Items_Product_ID_FK
级联product_Information(product_id),加上ON DELETE CASCADE后，如果主表order_items删除 一条记录，那么product_Information中对应的关联 的数据也跟着删除

MySQL 如何删除有外键约束的表数据

在MySQL中删除一张表或一条数据的时候，出现
[Err] 1451 -Cannot deleteorupdatea parent row:
aforeignkeyconstraintfails (...)

这是因为MySQL中设置了foreign key关联，造成无法更新或删除数据。可以通过设置FOREIGN_KEY_CHECKS变量来避免这种情况。

禁用外键约束，我们可以使用:

SET FOREIGN_KEY_CHECKS=0;

然后再删除数据

启动外键约束，我们可以使用:
SET FOREIGN_KEY_CHECKS=1;

查看当前FOREIGN_KEY_CHECKS的值，可用如下命令：
SELECT @@FOREIGN_KEY_CHECKS;