mysql数据库定时任务

– 相关配置
SHOW VARIABLES LIKE ‘event%’; – 查看事件是否开启
set GLOBAL event_scheduler = 1; – 将事件计划开启
SET GLOBAL event_scheduler = 0; – 将事件计划关闭
ALTER EVENT e_test ON COMPLETION PRESERVE ENABLE; – 开启事件定时任务
ALTER EVENT e_test ON COMPLETION PRESERVE DISABLE; – 关闭事件定时任务
SHOW EVENTS ; – 查看事件

– 存储过程
CREATE PROCEDURE p_test()
BEGIN
INSERT INTO test(name, create_time) values(‘testName’, now());
END

– 定时任务
CREATE EVENT e_test
ON SCHEDULE EVERY 30 SECOND
ON COMPLETION PRESERVE DISABLE
DO CALL p_test();