MySQLタイマオープン、実装コードの呼び出し

 
  
CREATE TABLE t 
  
( 
  
v VARCHAR(100) NOT NULL 
  
) ENGINE INNODB DEFAULT CHARSET=utf8; 
  
              
  
DELIMITER $$ 
  
DROP PROCEDURE IF EXISTS e_test $$ 
  
CREATE PROCEDURE e_test() 
  
BEGIN 
  
INSERT INTO t VALUES('1'); 
  
END $$ 
  
DELIMITER ; 
  
        MySQL   GLOBAL event_scheduler   on   1 
  
--           
  
SHOW VARIABLES LIKE '%sche%'; 
  
--       0：off 1：on 
  
SET GLOBAL event_scheduler = 1; 
  
--      
  
--        e_test()     
  
CREATE EVENT IF NOT EXISTS event_test 
  
ON SCHEDULE EVERY 1 SECOND 
  
ON COMPLETION PRESERVE 
  
DO CALL e_test(); 
  
--      
  
ALTER EVENT event_test ON 
  
COMPLETION PRESERVE ENABLE; 
  
--      
  
ALTER EVENT event_test ON 
  
COMPLETION PRESERVE DISABLE; 
  
              
  
CREATE EVENT EVENT1 
  
ON SCHEDULE EVERY 9 DAY STARTS NOW() 
  
ON COMPLETION PRESERVE ENABLE 
  
DO 
  
BEGIN 
  
CALL TOTAL(); 
  
END 
  
        1     
  
CREATE EVENT EVENT2 
  
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 
  
BEGIN 
  
CALL STAT(); 
  
END 
  
         2    
  
CREATE EVENT TOTAL_SEASON_EVENT 
  
ON SCHEDULE EVERY 1 QUARTER STARTS DATE_ADD(DATE_ADD(DATE( CONCAT(YEAR(CURDATE()),'-',ELT(QUARTER(CURDATE()),1,4,7,10),'-',1)),INTERVAL 1 QUARTER),INTERVAL 2 HOUR) 
  
ON COMPLETION PRESERVE ENABLE 
  
DO 
  
BEGIN 
  
CALL SEASON_STAT(); 
  
END 
  
  1 1        
  
CREATE EVENT TOTAL_YEAR_EVENT 
  
ON SCHEDULE EVERY 1 YEAR STARTS DATE_ADD(DATE(CONCAT(YEAR(CURDATE()) + 1,'-',1,'-',1)),INTERVAL 4 HOUR) 
  
ON COMPLETION PRESERVE ENABLE 
  
DO 
  
BEGIN 
  
CALL YEAR_STAT(); 
  
END