mysql - 从两个表中删除数据

Question

我想从我的两个表中删除数据:staff 和 staff_take_courses。SQLCommand 行不断给出错误:

ERROR 1451 (23000): Cannot delete or update a parent row: a foreign key constraint fails (`Exclusif`.`staff_take_courses`, CONSTRAINT `fk_staff_has_courses_staff1` FOREIGN KEY (`staff_id`) REFERENCES `staff` (`id`) ON DELETE NO ACTION O
N UPDATE NO ACTION)

这里是查询:

delete s, stc from staff s inner join staff_take_courses stc on stc.staff_id = s.id where s.id= '$id';

Answer 1

为什么你可以在两条语句中删除:

 DELETE FROM staff_take_courses WHERE staff_take_courses.staff_id= '$id';
 DELETE FROM staff WHERE staff.id= '$id';

肯定是表之间的关系有问题。这不允许您从表中删除