MySQL

A collection of 1 post

MySQL 定时任务

MySQL 定时任务

查询定时任务是否开启 show variables like 'event_scheduler'; Variable_name Value event_scheduler OFF OFF 为关闭,ON 为开启 开启定时任务 set global event_scheduler = on; 创建定时任务 CREATE [DEFINER = { user | CURRENT_USER }] EVENT [IF NOT EXISTS] event_