mysql - 添加触发器时语法错误

Question

我有程序:

    CREATE PROCEDURE channge_max_priority()
    BEGIN
      update feeds set max_post_priority =
        (
            select max(feed_posts.priority)
            from feed_posts
            where feed_posts.feed_id = feed_id
        )
        where feeds.id = feed_id;
    END  

我想创建三个触发器:

      CREATE TRIGGER feed_post_after_test AFTER INSERT (And update and delete ) ON feed_posts
      FOR EACH ROW EXECUTE PROCEDURE change_max_priority();

程序工作正常，但是当我尝试启动触发器时 - 我收到错误:

Error in query (1064): Syntax error near 'PROCEDURE change_max_priority()' at line 2

Answer 1

您的名称过程中有一个双 nn :

替换:

CREATE PROCEDURE channge_max_priority()

由

CREATE PROCEDURE change_max_priority()