我们如何获取触发器的元数据？
可以在INFORMATION_SCHEMA数据库的帮助下完成。以下语句将为我们提供触发器的元数据-
mysql> Select trigger_schema, trigger_name, action_statement
-> from information_schema.triggers\G
*************************** 1. row ***************************
trigger_schema: query
trigger_name: trigger_before_delete_sample
action_statement: BEGIN
SET @count = if (@count IS NULL, 1, (@count+1));
INSERT INTO sample_rowaffected values (@count);
END
*************************** 2. row ***************************
trigger_schema: query
trigger_name: before_inser_studentage
action_statement: IF NEW.age < 0 THEN SET NEW.age = 0;
END IF
*************************** 3. row ***************************
trigger_schema: sys
trigger_name: sys_config_insert_set_user
action_statement: BEGIN IF @sys.ignore_sys_config_triggers != true AND
NEW.set_by IS NULL THEN SET NEW.set_by = USER(); END IF; END
*************************** 5. row ***************************
trigger_schema: sys
trigger_name: sys_config_update_set_user
action_statement: BEGIN IF @sys.ignore_sys_config_triggers != true AND
NEW.set_by IS NULL THEN SET NEW.set_by = USER(); END IF; END
4 rows in set (0.03 sec)热门推荐
10 读书祝福语女生短句简短
11 感谢同事新婚祝福语简短
12 感谢教官文案祝福语简短
13 员工聚会蛋糕祝福语简短
14 元宵发客户祝福语简短
15 给团队信心祝福语简短
16 医美的祝福语大全简短
17 异国姻缘的祝福语简短
18 兄妹拍照祝福语简短的话