MySQL Event Viewer Usage Introduction

to see if the event Scheduler is currently turned on
SHOW VARIABLES like ' Event_scheduler ';

Turn on Event Viewer
SET GLOBAL event_scheduler = 1;

Create Event
Syntax:
CREATE EVENT [IF not EXISTS] Event_Name
On SCHEDULE SCHEDULE
[on completion [NOT] PRESERVE]
[ENABLE | DISABLE]
[COMMENT ' COMMENT ']
Do sql_statement;

Example:
CREATE EVENT updateinfostatus
On SCHEDULE every MINUTE
Do
UPDATE ' jd_article ' SET ' status ' = 0 WHERE ' status ' = 1 and ' Date ' <= now ();

Modifying Events
Syntax:
ALTER EVENT event_name
[on SCHEDULE SCHEDULE]
[RENAME to New_event_name]
[on completion [NOT] PRESERVE]
[COMMENT ' COMMENT ']
[ENABLE | DISABLE]
[do sql_statement]

Example:
ALTER EVENT updateinfostatus
On SCHEDULE every MINUTE
Do
UPDATE ' jd_article ' SET ' status ' = 0 WHERE ' status ' = 1 and ' Date ' <= now ();

Delete Event
DROP EVENTS IF EXISTS updateinfostatus

Temporary shutdown Events
ALTER EVENTS updateinfostatus DISABLE

Turn on Events
ALTER EVENTS updateinfostatus ENABLE

View Event Details
SELECT * from INFORMATION_SCHEMA. EVENTS WHERE event_name = ' updateinfostatus ' and Event_schema = ' JDWC '

View All Events
SHOW EVENTS

viewing event creation Information
SHOW CREATE EVENT updateinfostatus

MySQL Event Viewer Usage Introduction