这可以借助 information_schema 数据库来完成。以下语句将为我们提供事件的元数据 -
mysql> select * from information_schema.events where event_name like '%event%' and event_schema = 'query'\g*************************** 1. row *************************** event_catalog: def event_schema: query event_name: testing_event6 definer: root@localhost time_zone: system event_body: sql event_definition: insert into event_message(message,generated_at) values('event altered', now()) event_type: one time execute_at: 2017-11-22 20:03:52 interval_value: null interval_field: null 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 starts: null ends: null status: disabled on_completion: preserve created: 2017-11-22 20:02:52 last_altered: 2017-11-22 21:01:17 last_executed: 2017-11-22 20:03:52 event_comment: originator: 0character_set_client: cp850collation_connection: cp850_general_ci database_collation: latin1_swedish_ci*************************** 2. row *************************** event_catalog: def event_schema: query event_name: testing_event_with_preserves definer: root@localhost time_zone: system event_body: sql event_definition: insert into event_messages(message, generated_at) values('altered',now()) event_type: recurring execute_at: null interval_value: 1 interval_field: minute 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 starts: 2017-11-22 21:03:01 ends: null status: disabled on_completion: preserve created: 2017-11-22 20:35:12 last_altered: 2017-11-22 21:04:42 last_executed: 2017-11-22 20:35:12 event_comment: originator: 0character_set_client: cp850collation_connection: cp850_general_ci database_collation: latin1_swedish_ci2 rows in set (0.00 sec)
以上就是我们如何获取mysql事件的元数据？的详细内容。