MySql定时任务

stored procedure创建create procedure sp_name()begin………end调用call sp_name()注意：存储过程名称后面必须加括号，哪怕该存储过程没有参数传递删除drop procedure sp_name其他1.show procedure status显示数据库中所有存储的存储过程基本信息，包括所属数据库，存储过程名称，创建时间等2.show create procedure sp_name显示某一个存储过程的详细信息例子:CREATE PROCEDURE `bag_app_flow`()insert into bag_app_flowselect pid,avg(in_speed),avg(out_speed),max(log_time) log_timefrom bag_app_flow_rawwhere hour(now()) - hour(log_time) = 1group by pid,date_format(log_time,'%Y-%m-%d %H');

--------------event使用下列的任意一句开启计划任务：           SET GLOBAL event_scheduler = ON;           SET @@global.event_scheduler = ON;           SET GLOBAL event_scheduler = 1;           SET @@global.event_scheduler = 1;Event Scheduler创建的基本语法是：          CREATE EVENT                 [IF NOT EXISTS]               event_name                   ON SCHEDULE schedule             [ON COMPLETION [NOT] PRESERVE]           [ENABLE | DISABLE]                 [COMMENT 'comment']                DO sql_statement  如果要调用procedure    call sp_name() ,如create event flow_jobon schedule every 1 hourstarts '2009-12-26 18:06:00'docall bag_ip_flow();如果有多个procedures,则要加begin...end,如create event flow_jobon schedule every 1 hourstarts '2009-12-26 18:06:00'dobegincall  bag_app_flow();call bag_ip_flow();call bag_ip_group_flow();end

转载于:https://www.cnblogs.com/dfzone/p/4439163.html

相关资源：MySQL定时任务脚本