Mysql定时任务&存储过程

set GLOBAL event_scheduler = 1; --  将事件计划开启
 
 SHOW VARIABLES LIKE '%event_sche%'; -- 查看event是否开启
 

SHOW EVENTS ;  -- 查看事件任务 

ALTER EVENT e_test ON COMPLETION PRESERVE ENABLE; 

   set time_zone = '+8:00';  -- 设置时区
   SHOW VARIABLES LIKE '%time_zone%'; -- 显示时区

create event ashiq on schedule at '2011-06-01 11:00:00' do update bsp set ccrid = 'ashiq'

创建一个event ，默认需要@localhost. 也就是在本机上运行，远程会出现错误提示：

Error Code: 1044. Access denied for user 'root'@'%' to database 'redfish' 0.078 sec

show events 

alter event e_SentHuoDanHao

on schedule every '09:00:00' hour

do call senthuodanhao();