我正在从MYSQL的两个表中删除选定的行,这两个表都有外键。DELETE d,b INNER JOIN B as d on b.bid=d.bid WHERE b.name LIKE '%xxxx%';Error: Cannot delete or update a parent row: a foreignkey constraint
fails (`yyy/d`, CON
无法在MySQL工作台中添加外键约束/*!varchar(11) NOT NULL, `expected_price` int(11) NOT NULL,
FOREIGNKEY (`van_id`) REFERENCES `van` (`id`) ON DELETE SET NULL,
FOREIGN</em