</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