OneToMany关系。如何删除行？

Question

你好。我刚刚学会了如何选择所有相关的数据，比方说，行 tennismatch.ID = 1：

SELECT * FROM tennismatch m 
JOIN tennismatch_tennisset ms 
ON m.`ID` = ms.`TennisMatch_ID` 
JOIN tennisset s 
ON ms.`mapOfSets_ID` = s.`ID` 
JOIN tennisset_game sg 
ON s.`ID` = sg.`TennisSet_ID` 
JOIN game g 
ON sg.`gamesMap_ID` = g.`ID` 
JOIN game_point gp 
ON g.`ID` =gp.`Game_ID` 
JOIN point p 
ON gp.`points_ID` = p.`ID` 
WHERE m.`ID` = 1 

，但我想不出如何删除这一切。 非常感谢提前。

Answer 1

使用DELETE JOIN语句

DELETE m, s, g, p, ms, sg, gp 
FROM tennismatch m 
JOIN tennismatch_tennisset ms ON m.ID = ms.TennisMatch_ID 
JOIN tennisset s ON ms.mapOfSets_ID = s.ID 
JOIN tennisset_game sg ON s.ID = sg.TennisSet_ID 
JOIN game g ON sg.gamesMap_ID = g.ID 
JOIN game_point gp ON g.ID = gp.Game_ID 
JOIN point p ON gp.points_ID = p.ID 
WHERE m.ID = 1