MYSQL 事件高度器
<div id="cnblogs_post_body">要查看当前是否已开启事件调度器SHOW VARIABLES LIKE 'event_scheduler';
开启事件高度器
SET GLOBAL event_scheduler = 1;
创建事件
语法：
CREATE EVENT event_name
ON SCHEDULE schedule
PRESERVE]
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
PRESERVE]
实例：
ALTER EVENT updateInfoStatus
ON SCHEDULE EVERY 30 MINUTE
DO
UPDATE `jd_article` SET `status` = 0 WHERE `status` = 1 AND `date` <= now( );
删除事件
DROP EVENT IF EXISTS updateInfoStatus
临时关闭事件
ALTER EVENT updateInfoStatus DISABLE
开启事件
ALTER EVENT updateInfoStatus ENABLE
查看事件详细信息
SELECT * FROM INFORMATION_SCHEMA.EVENTS WHERE EVENT_NAME = 'updateInfoStatus' AND EVENT_SCHEMA = 'jdwc'
查看所有事件
SHOW EVENTS
查看事件创建信息
SHOW CREATE EVENT updateInfoStatus
页:
[1]