这可以借助 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_sampleaction_statement: beginset @count = if (@count is null, 1, (@count+1));insert into sample_rowaffected values (@count);end*************************** 2. row *************************** trigger_schema: query trigger_name: before_inser_studentageaction_statement: if new.age < 0 then set new.age = 0;end if*************************** 3. row *************************** trigger_schema: sys trigger_name: sys_config_insert_set_useraction_statement: begin if @sys.ignore_sys_config_triggers != true andnew.set_by is null then set new.set_by = user(); end if; end*************************** 5. row *************************** trigger_schema: sys trigger_name: sys_config_update_set_useraction_statement: begin if @sys.ignore_sys_config_triggers != true andnew.set_by is null then set new.set_by = user(); end if; end4 rows in set (0.03 sec)
以上就是我们如何获取触发器的元数据？的详细内容。