要查看当前是否已开启事件调度器 SHOW VARIABLES LIKE 'event_scheduler'; 开启事件查看器 SET GLOBAL event_scheduler = 1; 创建事件 语法： CREATE EVENT [IF NOT EXISTS] event_name ON SCHEDULE schedule [ON COMPLETION [N
要查看当前是否已开启事件调度器 SHOW VARIABLES LIKE 'event_scheduler'; 开启事件查看器 SET GLOBAL event_scheduler = 1; 创建事件 语法： CREATE EVENT [IF NOT EXISTS] event_name ON SCHEDULE schedule [ON COMPLETION [NOT] PRESERVE] [ENABLE | DISABLE] [COMMENT 'comment'] DO sql_statement; 实例： CREATE EVENT updateInfoStatus ON SCHEDULE EVERY 30 MINUTE DO UPDATE `jd_article` SET `status` = 0 WHERE `status` = 1 AND `date` <= now( ); 修改事件 语法： ALTER EVENT event_name [ON SCHEDULE schedule] [RENAME TO new_event_name] [ON COMPLETION [NOT] PRESERVE] [COMMENT 'comment'] [ENABLE | DISABLE] [DO sql_statement] 实例： ALTER EVENT updateInfoStatus ON SCHEDULE EVERY 30 MINUTE DO UPDATE `jd_article` SET `status` = 0 WHERE `status` = 1 AND `date` <= now( ); 删除事件 DROP EVENTS IF EXISTS updateInfoStatus 临时关闭事件 ALTER EVENTS updateInfoStatus DISABLE 开启事件 ALTER EVENTS updateInfoStatus ENABLE 查看事件详细信息 SELECT * FROM INFORMATION_SCHEMA.EVENTS WHERE EVENT_NAME = 'updateInfoStatus' AND EVENT_SCHEMA = 'jdwc' 查看所有事件 SHOW EVENTS 查看事件创建信息 SHOW CREATE EVENT updateInfoStatus 作者 Zhou Hr
