插入外键约束

Question

CREATE TABLE makeModel(
makeID INT NOT NULL DEFAULT '0',
modelID INT NOT NULL DEFAULT '0',
PRIMARY KEY (makeID , modelID),
FOREIGN KEY (makeID) REFERENCES make(id),
FOREIGN KEY (modelID) REFERENCES model(id)
);
INSERT INTO makeModel (makeID)
SELECT DISTINCT (make) FROM vehicle;

在上面的代码中，我想将列makefrom vehicles的不同值添加到makeModel中的列makeID中，但我得到了错误

INSERT INTO makeModel(makeID(SELECT DISTINCT(make(FROM vehicle错误代码：1452。无法添加或更新子行：外键约束失败(`dealery`.makemodel`，constraint`makemodel_ibfk_2`foreign key(`modelID`(REFERENCES`model`(`ID`((

Answer 1

您还需要插入model字段，因为它也是一个外键。

INSERT INTO makeModel(makeID, modelID)
SELECT DISTINCT make, model
FROM vehicle