information_schema系统表——EVENTS
来源:互联网 发布:php商品管理系统 编辑:程序博客网 时间:2024/05/16 17:04
调度计划事件信息表
The EVENTS
table provides information about scheduled events, which are discussed in Section 23.4, “Using the Event Scheduler”. The SHOW Name
values correspond to column names of the SHOW EVENTS
statement.
INFORMATION_SCHEMA
NameSHOW
NameEVENT_CATALOG
def
, MySQL extensionEVENT_SCHEMA
Db
MySQL extensionEVENT_NAME
Name
MySQL extensionDEFINER
Definer
MySQL extensionTIME_ZONE
Time zone
MySQL extensionEVENT_BODY
MySQL extensionEVENT_DEFINITION
MySQL extensionEVENT_TYPE
Type
MySQL extensionEXECUTE_AT
Execute at
MySQL extensionINTERVAL_VALUE
Interval value
MySQL extensionINTERVAL_FIELD
Interval field
MySQL extensionSQL_MODE
MySQL extensionSTARTS
Starts
MySQL extensionENDS
Ends
MySQL extensionSTATUS
Status
MySQL extensionON_COMPLETION
MySQL extensionCREATED
MySQL extensionLAST_ALTERED
MySQL extensionLAST_EXECUTED
MySQL extensionEVENT_COMMENT
MySQL extensionORIGINATOR
Originator
MySQL extensionCHARACTER_SET_CLIENT
character_set_client
MySQL extensionCOLLATION_CONNECTION
collation_connection
MySQL extensionDATABASE_COLLATION
Database Collation
MySQL extensionNotes:
The
EVENTS
table is a nonstandard table.EVENT_CATALOG
: The value of this column is alwaysdef
.EVENT_SCHEMA
: The name of the schema (database) to which this event belongs.EVENT_NAME
: The name of the event.DEFINER
: The account of the user who created the event, in'
format.user_name
'@'host_name
'TIME_ZONE
: The event time zone, which is the time zone used for scheduling the event and that is in effect within the event as it executes. The default value isSYSTEM
.EVENT_BODY
: The language used for the statements in the event'sDO
clause; in MySQL 5.7, this is alwaysSQL
.This column is not to be confused with the column of the same name (now named
EVENT_DEFINITION
) that existed in earlier MySQL versions.EVENT_DEFINITION
: The text of the SQL statement making up the event'sDO
clause; in other words, the statement executed by this event.EVENT_TYPE
: The event repetition type, eitherONE TIME
(transient) orRECURRING
(repeating).EXECUTE_AT
: For a one-time event, this is theDATETIME
value specified in theAT
clause of theCREATE EVENT
statement used to create the event, or of the lastALTER EVENT
statement that modified the event. The value shown in this column reflects the addition or subtraction of anyINTERVAL
value included in the event'sAT
clause. For example, if an event is created usingON SCHEDULE AT CURRENT_TIMESTAMP + '1:6' DAY_HOUR
, and the event was created at 2006-02-09 14:05:30, the value shown in this column would be'2006-02-10 20:05:30'
.If the event's timing is determined by an
EVERY
clause instead of anAT
clause (that is, if the event is recurring), the value of this column isNULL
.INTERVAL_VALUE
: For recurring events, this column contains the numeric portion of the event'sEVERY
clause.For a one-time event (that is, an event whose timing is determined by an
AT
clause), this column isNULL
.INTERVAL_FIELD
: For recurring events, this column contains the units portion of theEVERY
clause governing the timing of the event. Thus, this column contains a value such as 'YEAR
', 'QUARTER
', 'DAY
', and so on.For a one-time event (that is, an event whose timing is determined by an
AT
clause), this column isNULL
.SQL_MODE
: The SQL mode in effect when the event was created or altered, and under which the event executes. For the permitted values, see Section 5.1.8, “Server SQL Modes”.STARTS
: For a recurring event whose definition includes aSTARTS
clause, this column contains the correspondingDATETIME
value. As with theEXECUTE_AT
column, this value resolves any expressions used.If there is no
STARTS
clause affecting the timing of the event, this column isNULL
ENDS
: For a recurring event whose definition includes aENDS
clause, this column contains the correspondingDATETIME
value. As with theEXECUTE_AT
column, this value resolves any expressions used.If there is no
ENDS
clause affecting the timing of the event, this column isNULL
.STATUS
: One of the three valuesENABLED
,DISABLED
, orSLAVESIDE_DISABLED
.SLAVESIDE_DISABLED
indicates that the creation of the event occurred on another MySQL server acting as a replication master and was replicated to the current MySQL server which is acting as a slave, but the event is not presently being executed on the slave. See Section 16.4.1.16, “Replication of Invoked Features”, for more information.ON_COMPLETION
: One of the two valuesPRESERVE
orNOT PRESERVE
.CREATED
: The date and time when the event was created. This is aTIMESTAMP
value.LAST_ALTERED
: The date and time when the event was last modified. This is aTIMESTAMP
value. If the event has not been modified since its creation, this column holds the same value as theCREATED
column.LAST_EXECUTED
: The date and time when the event last executed. ADATETIME
value. If the event has never executed, this column isNULL
.LAST_EXECUTED
indicates when the event started. As a result, theENDS
column is never less thanLAST_EXECUTED
.EVENT_COMMENT
: The text of a comment, if the event has one. If not, the value of this column is an empty string.ORIGINATOR
: The server ID of the MySQL server on which the event was created; used in replication. The default value is 0.CHARACTER_SET_CLIENT
: The session value of thecharacter_set_client
system variable when the event was created.COLLATION_CONNECTION
: The session value of thecollation_connection
system variable when the event was created.DATABASE_COLLATION
: The collation of the database with which the event is associated.
- information_schema系统表——EVENTS
- information_schema系统表——CHARACTER_SETS
- information_schema系统表——COLLATIONS
- information_schema系统表——COLLATION_CHARACTER_SET_APPLICABILITY
- information_schema系统表——COLUMNS
- information_schema系统表——COLUMN_PRIVILEGES
- information_schema系统表——ENGINES
- information_schema系统表——FILES
- information_schema系统表——PROCESSLIST
- information_schema系统表——TABLES
- information_schema系统表——TABLESPACES
- information_schema系统表——TABLE_CONSTRAINTS
- information_schema系统表——TABLE_PRIVILEGES
- information_schema系统表——TRIGGERS
- information_schema系统表——USER_PRIVILEGES
- information_schema系统表——GLOBAL_STATUS and SESSION_STATUS
- Mysql information_schema系统表元数据
- WCE之“系统事件”——System/Events
- Jfinal3.0写的增删改查(CRUD)实例
- shiro框架下的logout说明
- php判断元素是否在二维数组中
- 测试
- JSONP跨域问题
- information_schema系统表——EVENTS
- shell 讲字符串当命令将输出写入文件,并处文件中读出来
- JS -- Immutable.js & React & Redux
- kaufman adaptive moving average
- jupyternotebook 解压文件
- linux shell 99乘法表
- 学的几个简单的SQL语句
- NSWindow 直接加载NSViewController
- HBase源码系列(三)HMaster启动过程