MYSQL 定时任务调用存储过程

</pre>创建存储过程:<pre name="code" class="sql">drop procedure IF EXISTS case_inter_sum;
create procedure case_inter_sum()
begin
  DECLARE casecnt INT DEFAULT 0;
  DECLARE intercnt INT DEFAULT 0;
  DECLARE datetime DATETIME DEFAULT NOW();
  set @casecnt = (SELECT COUNT(1)  FROM CASE_INFO);
  set @intercnt =(SELECT COUNT(1)  FROM INTERFACE_INFO);
  INSERT INTO CASE_INTER_SUM(sum_num,sum_state,sum_date) VALUES (@casecnt,'case',datetime);
  INSERT INTO CASE_INTER_SUM(sum_num,sum_state,sum_date) VALUES (@intercnt,'interface',datetime);
 end

在mysql命令行建EVENT：

   //每个月1号1点执行

drop EVENT GETINNERSUM;
CREATE event if not exists GETINNERSUM  
ON SCHEDULE EVERY 1 MONTH STARTS DATE_ADD(DATE_ADD(DATE_SUB(CURDATE(),INTERVAL DAY(CURDATE())-1 DAY), INTERVAL 1 MONTH),INTERVAL 1 HOUR)  
ON COMPLETION PRESERVE ENABLE  
DO  
   C