mysql - 无法在 phpmyadmin 的系统表上创建触发器

Question

据我所知，我的查询是正确的，但给出了错误:

CREATE TRIGGER `invite` AFTER INSERT ON `invite_page`
 FOR EACH ROW BEGIN
    Insert into userpost(userid,url,title,preview,sentiment,time) 

                        values(NEW.userid,NEW.url,NEW.title,NEW.preview,NEW.sentiment,NEW.time);

    Insert into urlcontent(userid,url,title,preview,sentiment,time)

                        values(NEW.userid,NEW.url,NEW.title,NEW.preview,NEW.sentiment,NEW.time);
END

错误是:

#1465 - Triggers can not be created on system tables

Answer 1

就我而言，您不能在系统表上创建触发器。

参见 mysql: Cant we create triggers on system tables?获取更多信息。