The INFORMATION_SCHEMA EVENTS Table 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 . For a recurring event, the number of intervals to wait between event executions. For a transient event, the value is always  NULL . The time units used for the interval which a recurring event waits before repeating. For a transient event, the value is always  NULL . 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” . 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 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 . 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. One of the two values  PRESERVE  or  NOT PRESERVE . The date and time when the event was created. This is a  TIMESTAMP  value. 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. • LAST_ALTERED • CREATED • ON_COMPLETION • STATUS • ENDS • STARTS • SQL_MODE • INTERVAL_FIELD • INTERVAL_VALUE 4789