mysql event例子

DELIMITER $$


CREATE EVENT `fatalsun_event` ON SCHEDULE EVERY 1 DAY STARTS '2013-04-17 04:00:00' ON COMPLETION PRESERVE ENABLE DO BEGIN  
   truncate report_host_broken;
   call fatalhostsum_proc();
   truncate report_hostgroup_broken;
   call fatalgroupsum_proc();
   truncate report_top;
   call fatatopsum_proc();
 END$$


DELIMITER ;