我正在从MYSQL的两个表中删除所选行,这两个表具有外键。
DELETE d,b
FROM A as b
INNER JOIN B as d on b.bid=d.bid WHERE b.name LIKE '%xxxx%';
尽管我试图从两个表中删除数据,MYSQL仍然抱怨外键问题:
Error: Cannot delete or update a parent row: a foreign key constraint
fails (`yyy/d`, CONSTRAINT `fk_d_bid` FOREIGN KEY (`bid`) REFERENCES
`b` (`bid`) ON DELETE NO ACTION ON UPDATE NO ACTION)
这里最好的解决方案是从两个表中删除吗?