mysql使用事件控制存储过程创建视图

create procedure proc_errorCount_data_report()
 --  统计的数据有单表多规则的检测出来的错误数量可能大于单表的数据量.
  BEGIN 
CREATE or replace  VIEW  view_errorCount_data_report as 
(
SELECT sum(b.ERROR_COUNT) as counts  from (
SELECT MAX(a.CREATE_TIME) AS max_time,a.BIZ_ID,a.RULE_ID,a.ERROR_COUNT,a.TABLE_NAME FROM adqm_job_report a WHERE a.RULE_ID!='-1' AND a.ERROR_COUNT >0 GROUP BY a.rule_id,a.biz_id ORDER BY a.BIZ_ID
 ) b 
);
  END 

 
-- 创建事件60s执行一次
CREATE EVENT IF NOT EXISTS event_errorCount_data ON SCHEDULE EVERY 60 SECOND
ON COMPLETION PRESERVE
DO call proc_errorCount_data_report();