Can I create Trigger on mysql base

Asked Mar 26 '13 at 13:49

Active Mar 26 '13 at 13:49

Viewed 38 times

I was trying to create a trigger on mysql database but on error happened. My code is:

DELIMITER //
CREATE TRIGGER alterTable AFTER INSERT ON mysql.general_log 
FOR EACH ROW 
BEGIN
     IF NEW.argument LIKE "ALTER %" THEN
         INSERT INTO altersLog (queryAlter) VALUES (NEW.argument);
     END IF;
END//
DELIMITER ;

When I run this code, on error is showed:

SQL Error (1465): Triggers can not be created on system tables

Can I create triggers on mysql database?

Thanks

asked Mar 26 '13 at 13:49

user2211688

2

The error seems self explanatory. – Kermit Mar 26 '13 at 13:53
I suspect that the limit is there to prevent corruption of those tables. If a trigger failed it could prevent sql from performing some 'essential operations'. – ethrbunny Mar 26 '13 at 13:54
1

The answer is in your question... – Jocelyn Mar 26 '13 at 14:21

Can I create Trigger on mysql base

0 Answers0