mysql-定时任务

 

将事件计划开启: set global event_scheduler=1; 

 

创建事件e_student

CREATE EVENT if not exists e_student 
          on schedule every 30 second 
          on completion preserve 
     do call pro_test();