MYSQL event height Server

For MYSQL event height server, check whether the event scheduler show variables like 'event _ scheduler 'is enabled. For www.2cto.com, set global event_sched = 1. Create event Syntax: create event [if not exists] event_nameON SCHEDULE schedule [on completion [NOT] PRESERVE] [ENABLE | DISABLE] [COMMENT 'comment'] DO SQL _statement; instance: create event updateInfoStatus on schedule every 30 minute do update 'jd _ article 'set 'status' = 0 WHERE 'status' = 1 AND 'date' <= now (); www.2cto.com: alter event event_name [on schedule schedule] [rename to new_event_name] [on completion [NOT] PRESERVE] [COMMENT 'comment'] [ENABLE | DISABLE] [DO SQL _statement] instance: alter event updateInfoStatus on schedule every 30 minute do update 'jd _ article 'set 'status' = 0 WHERE 'status' = 1 AND 'date' <= now (); delete event drop events if exists updateInfoStatus temporarily close event alter events updateInfoStatus disable enable event alter events updateInfoStatus ENABLE www.2cto.com view event details SELECT * FROM region WHERE EVENT_NAME = 'updateinfostatus' AND EVENT_SCHEMA = 'jdwc 'view all event show events view EVENT creation Information show create event updateInfoStatus author Zhou Hr