使用内连接删除行时具有外键约束 [英] Having Foreign key constrain while deleting rows using inner join

问题描述

DELETE
    a,b,c
FROM 
sp_movie.movie_db AS a
INNER JOIN sp_movie.movie_time AS b
      ON a.Movie_ID = b.Movie_ID
INNER JOIN sp_movie.movie_time AS c
      ON c.Movie_ID = a.Movie_ID
WHERE 
    a.Movie_ID = 29

我正在尝试从所有三个表中删除所有具有 Movie_ID = 29

I am trying to delete all the rows from all three tables which has the Movie_ID = 29

我什至尝试写这个删除一个 FROM.....

我有一个错误:错误代码:1451.无法删除或更新父行:外键约束失败(sp_movie.movie_actor, CONSTRAINT2FOREIGN KEY (Movie_ID) REFERENCESmovie_db(Movie_ID) ON DELETE NO ACTION ON UPDATE NO ACTION)

I am having an error : Error Code: 1451. Cannot delete or update a parent row: a foreign key constraint fails (sp_movie.movie_actor, CONSTRAINT2FOREIGN KEY (Movie_ID) REFERENCESmovie_db(Movie_ID) ON DELETE NO ACTION ON UPDATE NO ACTION)

推荐答案

我通过将 time 和 的外键引用操作设置为 on cascade 解决了这个问题>演员表

I solved it by setting the foreign key referenced action to on cascade for both time and actors table

这篇关于使用内连接删除行时具有外键约束的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！