mysql - Cricket Manager 的 SQL 查询

Question

我有一张 2 张 table

TEAMS -TeamId,TeamName,Country
Players-PlayerID,PlayerName,TotalScore,ToTalMatch,TotalRuns,AvgRunRate.

现在我想创建一个表TEAMPLAYERS..其中必须包含TEAMID，PlayerId...如果在TEAMS，PLAYER表中删除详细信息..则必须在第三表中删除数据..请帮助我

Answer 1

以下是如何通过级联删除创建具有外键约束的表。

CREATE TABLE TEAMPLAYERS (
.....
teamId int(11) NOT NULL,
playerId int(11) NOT NULL,
FOREIGN KEY(teamId)
REFERENCES TEAMS(teamId)
ON DELETE CASCADE,
FOREIGN KEY(playerId)
REFERENCES PLAYERS(playerId)
ON DELETE CASCADE
.....
);

注意:...将在 TEAMPLAYERS 表上填充其他所需的列/约束。此外，请参阅其他提出类似问题的帖子 MySQL foreign key constraints, cascade delete

希望这有帮助!