mysql - 查询中的插入、更新、删除语句

Question

我有以下表:Persons、Person_Categories 和 Persons_PersonCategories，它们是 n:m 关系的链接表。

我还编写了以下查询，但插入语句无法正常工作。插入、更新和删除是单独的语句。我收到的错误消息是“列计数与第 1 行的值计数不匹配”

SELECT Persons_PersonCategories.PersonID, PrsCategory
FROM Person_Categories
INNER JOIN Persons_PersonCategories
ON Persons_PersonCategories.PrsCatID = Person_Categories.PrsCatID

INSERT INTO Persons_PersonCategories
VALUES (:PrsCategory)

UPDATE Persons_PersonCategories
SET Persons_PersonCategories.PrsCatID = :PrsCatID
WHERE Person_Categories.PrsCatID = :OLD PrsCatID
AND Persons.PersonID = :OLD PersonID

DELETE FROM Persons_PersonCategories
WHERE Person_Categories.PrsCatID = :PrsCatID
AND Persons.PersonID = :PersonID;

任何帮助将不胜感激，赞

Answer 1

指定要更新的列:

INSERT INTO Persons_PersonCategories (PrsCategory) VALUES (:PrsCategory)

如果我没有正确猜出您要执行的操作，请用正确的列名称替换 PrsCategory。