For a one-time event, this is the DATETIME  value specified in the AT  clause of the CREATE EVENT statement used to create the event, or of the last ALTER EVENT  statement that modified the event. The value shown in this column reflects the addition or subtraction of any INTERVAL  value included in the event’s AT  clause. For example, if an event is created using ON SCHEDULE AT CURRENT_TIMESTAMP + ’1:6’ DAY_HOUR , and the event was created at 2018-02-09 14:05:30, the value shown in this column would be ’2018-02-10 20:05:30’ . If the event’s timing is determined by an EVERY  clause instead of an AT  clause (that is, if the event is recurring), the value of this column is NULL . 

• INTERVAL_VALUE 

For a recurring event, the number of intervals to wait between event executions. For a transient event, the value is always NULL . 

• INTERVAL_FIELD 

The time units used for the interval which a recurring event waits before repeating. For a transient event, the value is always NULL . 

• 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.11, “Server SQL Modes” . 

• STARTS 

The start date and time for a recurring event. This is displayed as a DATETIME  value, and is NULL  if no start date and time are defined for the event. For a transient event, this column is always NULL . For a recurring event whose definition includes a STARTS  clause, this column contains the corresponding DATETIME  value. As with the EXECUTE_AT  column, this value resolves any expressions used. If there is no STARTS  clause affecting the timing of the event, this column is NULL 

• ENDS 

For a recurring event whose definition includes a ENDS  clause, this column contains the corresponding DATETIME  value. As with the EXECUTE_AT  column, this value resolves any expressions used. If there is no ENDS  clause affecting the timing of the event, this column is NULL . 

• STATUS 

The event status. One of ENABLED , DISABLED , or SLAVESIDE_DISABLED . SLAVESIDE_DISABLED indicates that the creation of the event occurred on another MySQL server acting as a replication source and replicated to the current MySQL server which is acting as a replica, but the event is not presently being executed on the replica. For more information, see Section 17.5.1.16, “Replication of Invoked Features” . information. 

• ON_COMPLETION 

One of the two values PRESERVE  or NOT PRESERVE . 

• CREATED 

The date and time when the event was created. This is a TIMESTAMP  value. 

• LAST_ALTERED 

The date and time when the event was last modified. This is a TIMESTAMP  value. If the event has not been modified since its creation, this value is the same as the CREATED  value. 

