如何查看在我的数据库上运行的所有 MySQL 事件？
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/9057525/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
How do I see all MySQL events that are running on my database?
提问by Don P
I have a MySQL database. I am running two MySQL EVENTs. I need to get rid of one. I don't remember it's name. What do I do?
我有一个 MySQL 数据库。我正在运行两个 MySQL 事件。我需要摆脱一个。我不记得它的名字了。我该怎么办？
回答by
its simple SHOW EVENTSlists all of the events in the current schema
它的简单 SHOW EVENTS列出了当前模式中的所有事件
To see events for a specific schema, use the FROM clause. For example, to see events for the test schema, use the following statement:
要查看特定模式的事件，请使用 FROM 子句。例如，要查看测试模式的事件，请使用以下语句：
SHOW EVENTS FROM test;
回答by Michael Berkowski
The information_schema.EVENTStable is where to start.
该information_schema.EVENTS表是从哪里开始。
USE information_schema;
DESCRIBE EVENTS;
+----------------------+---------------+------+-----+---------------------+-------+
| Field | Type | Null | Key | Default | Extra |
+----------------------+---------------+------+-----+---------------------+-------+
| EVENT_CATALOG | varchar(64) | YES | | NULL | |
| EVENT_SCHEMA | varchar(64) | NO | | | |
| EVENT_NAME | varchar(64) | NO | | | |
| DEFINER | varchar(77) | NO | | | |
| TIME_ZONE | varchar(64) | NO | | | |
| EVENT_BODY | varchar(8) | NO | | | |
| EVENT_DEFINITION | longtext | NO | | NULL | |
| EVENT_TYPE | varchar(9) | NO | | | |
| EXECUTE_AT | datetime | YES | | NULL | |
| INTERVAL_VALUE | varchar(256) | YES | | NULL | |
| INTERVAL_FIELD | varchar(18) | YES | | NULL | |
| SQL_MODE | varchar(8192) | NO | | | |
| STARTS | datetime | YES | | NULL | |
| ENDS | datetime | YES | | NULL | |
| STATUS | varchar(18) | NO | | | |
| ON_COMPLETION | varchar(12) | NO | | | |
| CREATED | datetime | NO | | 0000-00-00 00:00:00 | |
| LAST_ALTERED | datetime | NO | | 0000-00-00 00:00:00 | |
| LAST_EXECUTED | datetime | YES | | NULL | |
| EVENT_COMMENT | varchar(64) | NO | | | |
| ORIGINATOR | bigint(10) | NO | | 0 | |
| CHARACTER_SET_CLIENT | varchar(32) | NO | | | |
| COLLATION_CONNECTION | varchar(32) | NO | | | |
| DATABASE_COLLATION | varchar(32) | NO | | | |
+----------------------+---------------+------+-----+---------------------+-------+
SELECT EVENT_NAME FROM EVENTS WHERE EVENT_SCHEMA = 'your_database_name';
回答by Korhan Ozturk
SHOW EVENTS\G
Which will bring you the list of all existing events. For Show EventsSyntax: http://dev.mysql.com/doc/refman/5.1/en/show-events.html
这将为您带来所有现有事件的列表。对于显示事件语法：http: //dev.mysql.com/doc/refman/5.1/en/show-events.html
回答by karthik
show events;
will show all the events .
将显示所有事件。
回答by Madacol
Show events with more details
显示更多详细信息的事件
SELECT * FROM information_schema.EVENTS
