trigger can not be created on system table in phpmyadmin

Question

My query is correct as per my knowledge, but gives error:

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

the error is:

#1465 - Triggers can not be created on system tables

score 1 · Accepted Answer · edited May 23 '17 at 12:14

1

As long as I'm concerned, you can't create triggers on system tables.

See mysql: Cant we create triggers on system tables? for more information.

edited May 23 '17 at 12:14

Community

1
1

answered Dec 16 '13 at 16:55

Minoru

1,680
3
20
44

But I am not creating on system table? all the table are created manually by me – user2129623 Dec 16 '13 at 16:57
Well, that's not what the error is saying. Is this the only statement you're making or you're making a lot of statements? – Minoru Dec 17 '13 at 13:34

trigger can not be created on system table in phpmyadmin

1 Answers1