mysql - 如何在触发器 INSERT AFTER mysql 中执行过程？

Question

我在这里发现了很多问题，例如: Execute procedure in a trigger

但不能在此处发表自己的评论以指定某些时刻。

我有触发器 INSERT AFTER，我在 phpmyadmin 中写道:

...

BEGIN
insert_log(1, :new.idArticle, :new.ArticleName, :new.ArticleTime, :new.ArticleCategory, :new.ArticleToUserID);
END
...

我得到错误:

MySQL: #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 '(1, :new.idArticle, :new.ArticleName, :new.ArticleTime, :new.ArticleCategory, :n' at line 2

你能告诉我哪里出了问题吗？

Answer 1

试试这个:

CREATE TRIGGER your_trigger
AFTER INSERT
    ON table_name FOR EACH ROW
BEGIN
      insert_log(1, NEW.idArticle,  NEW.ArticleName, NEW.ArticleTime,  NEW.ArticleCategory,     NEW.ArticleToUserID);
END;

另请注意，MySQL 的文档页面标题为“Trigger Syntax and Examples”，其中指出:

 Within the trigger body, the OLD and NEW keywords enable you to access columns 
 in the rows affected by a trigger. OLD and NEW are MySQL extensions to triggers; 
 they are not case sensitive.

如有任何问题，请告诉我!