sql - 触发自动将元组添加到关系

Question

我正在尝试在SQLITE上创建触发器，以在将某些内容添加到某个表时自动将元组添加到另一个表，但是首先，我想检查添加的内容是否属于另一个第三表。

这是我的触发器：

DROP TRIGGER IF EXISTS atualizaBibliotecas;

CREATE TRIGGER atualizaBibliotecas
AFTER INSERT ON FoiComprado
FOR EACH ROW
BEGIN
    SELECT CASE 
    WHEN 
    (
        SELECT count(*)
        FROM Album 
        WHERE idItem = NEW.idItem
    ) <> 0
    THEN INSERT INTO Possui(idItem, email, dataAquisicao) VALUES(11,'aaaa@bbbb.com', '2019-05-14');
END;

这是我收到的错误：

Error: near line 8: near "INSERT": syntax error

第8行：

CREATE TRIGGER atualizaBibliotecas

Answer 1

我相信你想要：-

CREATE TRIGGER atualizaBibliotecas
AFTER INSERT ON FoiComprado
FOR EACH ROW
   WHEN 
    (
        SELECT count(*)
        FROM Album 
        WHERE idItem = NEW.idItem
    ) <> 0
    BEGIN
    INSERT INTO Possui(idItem, email, dataAquisicao) VALUES(11,'aaaa@bbbb.com', '2019-05-14');
END;