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 of this column 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 of this column is always NULL . 

• 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. 

• Originator 

The server ID of the MySQL server on which the event was created; used in replication. This value may be updated by ALTER EVENT  to the server ID of the server on which that statement occurs, if executed on a source server. The default value is 0. 

• character_set_client 

The session value of the character_set_client  system variable when the event was created. 

• collation_connection 

The session value of the collation_connection  system variable when the event was created. 

• Database Collation 

The collation of the database with which the event is associated. 

For more information about SLAVESIDE_DISABLED  and the Originator  column, see Section 17.5.1.16, “Replication of Invoked Features” . 

Times displayed by SHOW EVENTS  are given in the event time zone, as discussed in Section 25.4.4, “Event Metadata” . 

