MySQL 触发器和 "Referencing"

Question

我是 MySQL 的新手。我完全有能力进行查询和创建表，但之前从未尝试过触发器。

CREATE TRIGGER TrigMora AFTER INSERT ON cliente
    REFERENCING NEW AS N
    INSERT INTO mora(Email) VALUES (N.Email);

我收到这个错误:

Error Code: 1064. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'REFERENCING NEW AS N INSERT INTO mora(Email) VALUES (N.Email)' at line 3

我想知道我做错了什么。这个想法似乎很基本。在对表“cliente”进行新插入后，“Email”行中的信息应复制到表“mora”。

Answer 1

只需删除“REFERENCING NEW AS N，并使用 NEW.Email”

您还缺少围绕触发代码的“BEGIN”和“END”

您还错过了“对于每一行”

查看mysql触发器引用，这里我复制你一个mysql触发器示例:

delimiter //
CREATE TRIGGER upd_check BEFORE UPDATE ON account
    FOR EACH ROW
    BEGIN
        IF NEW.amount < 0 THEN
            SET NEW.amount = 0;
        ELSEIF NEW.amount > 100 THEN
            SET NEW.amount = 100;
        END IF;
    END;//
delimiter ;

复制自:MYsql-reference