SHOW Statements | jon@ghidora | myschema | +----------------+----------+ 1 row in set (0.00 sec) mysql>  SHOW EVENTS\G *************************** 1. row *************************** Db: myschema Name: e_daily Definer: jon@ghidora Time zone: SYSTEM Type: RECURRING Execute at: NULL Interval value: 1 Interval field: DAY Starts: 2018-08-08 11:06:34 Ends: NULL Status: ENABLED Originator: 1 character_set_client: utf8mb4 collation_connection: utf8mb4_0900_ai_ci Database Collation: utf8mb4_0900_ai_ci To see events for a specific schema  use the  FROM  clause. For example  to see events for the  test schema  use the following statement: SHOW EVENTS FROM test; The  LIKE  clause  if present  indicates which event names to match. The  WHERE  clause can be given to select rows using more general conditions  as discussed in Section 26.8  “Extensions to SHOW Statements” . SHOW EVENTS  output has these columns: The name of the schema (database) to which the event belongs. The name of the event. The account of the user who created the event  in  ’ user_name ’@’ host_name ’  format. 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 is  SYSTEM . The event repetition type  either  ONE TIME  (transient) or  RECURRING  (repeating). 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 • Execute At 2930 • Type • Time zone • Definer • Name • Db