Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE
- /*[DEFINER = { user | CURRENT_USER }]*/
- TRIGGER `mysql`.`test` BEFORE DELETE
- ON `mysql`.`db`
- FOR EACH ROW BEGIN
- INSERT INTO cescnet.db_monitor (DB_name,user_name,dateandtime,operation_type) VALUES (mysql.db.Db,CURRENT_USER(),NOW(),'Delete');
- END;|
- Triggers can not be created on system tables
- grant super on *.* to root@localhost
- grant all on *.* to root@localhost
- Triggers can not be created on system tables
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement