查看当前计划任务:
选择数据库后show events;
查看是否开启计划任务:show global variables like '%event_scheduler%';
启动计划任务:
set global event_scheduler = on
mysql自动启动计划任务:编辑/etc/my.cnf文件,在[mysqld]下添加event_scheduler=1
修改
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
event_scheduler=1
创建计划任务:CREATE
DEFINER = 'root'@'192.168.0.1%'
EVENT hxl.e_test
ON SCHEDULE EVERY '1' MINUTE
STARTS '2016-03-07 14:18:03'
ON COMPLETION PRESERVE
DO
call sp_mytest()
--每分钟执行一次