我们如何获取MySQL事件的元数据?

2023年 8月 31日 72.0k 0

我们如何获取MySQL事件的元数据?

这可以借助 INFORMATION_SCHEMA 数据库来完成。以下语句将为我们提供事件的元数据 -

mysql> SELECT * from INFORMATION_SCHEMA.EVENTS WHERE EVENT_NAME LIKE '%event%' A

ND 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: 0
CHARACTER_SET_CLIENT: cp850
COLLATION_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: 0
CHARACTER_SET_CLIENT: cp850
COLLATION_CONNECTION: cp850_general_ci
DATABASE_COLLATION: latin1_swedish_ci
2 rows in set (0.00 sec)

登录后复制

以上就是我们如何获取MySQL事件的元数据?的详细内容,更多请关注每日运维网(www.mryunwei.com)其它相关文章!

相关文章

Oracle如何使用授予和撤销权限的语法和示例
Awesome Project: 探索 MatrixOrigin 云原生分布式数据库
下载丨66页PDF,云和恩墨技术通讯(2024年7月刊)
社区版oceanbase安装
Oracle 导出CSV工具-sqluldr2
ETL数据集成丨快速将MySQL数据迁移至Doris数据库

发布评论