-- 開啟定時(shí)器 0：off 1：on SET GLOBAL event_scheduler = 1;
-- 創(chuàng)建事件 --每隔一秒自動(dòng)調(diào)用e_test()存儲(chǔ)過程 CREATE EVENT IF NOT EXISTS event_test ON SCHEDULE EVERY 1 SECOND ON COMPLETION PRESERVE DO CALL e_test();
-- 開啟事件 ALTER EVENT event_test ON COMPLETION PRESERVE ENABLE;
-- 關(guān)閉事件 ALTER EVENT event_test ON COMPLETION PRESERVE DISABLE;
