mysql笔记—计划开启

首先查看计划事件是否开启:

mysql> show variables like '%scheduler%';

开启计划

SET GLOBAL event_scheduler = ON;
SET @@global.event_scheduler = ON;

SET GLOBAL event_scheduler = 1;
SET @@global.event_scheduler = 1;