mysql> select * from information_schema.triggers where trigger_schema = 'query'and event_object_table = 'student_info'\g*************************** 1. row *************************** trigger_catalog: def trigger_schema: query trigger_name: studentinfo_after_delete event_manipulation: delete event_object_catalog: def event_object_schema: query event_object_table: student_info action_order: 1 action_condition: null action_statement: begindeclare vuser varchar(30);select user() into vuser;insert into student_info_deleted(id,deleted_date,deleted_by) values(old.id,sysdate(),vuser);end action_orientation: row action_timing: afteraction_reference_old_table: nullaction_reference_new_table: null action_reference_old_row: old action_reference_new_row: new created: 2017-11-21 14:19:34.91 sql_mode: only_full_group_by,strict_trans_tables,no_zero_in_date,no_zero_date,error_for_division_by_zero,no_auto_create_user,no_engine_substitution definer: root@localhost character_set_client: cp850 collation_connection: cp850_general_ci database_collation: latin1_swedish_ci1 row in set (0.00 sec)
上面的结果集显示了名为“query”的数据库中“student_info”表上的触发器列表。
以上就是我们如何找到与特定 mysql 表关联的所有触发器？的详细内容。