mysql事件的开启和调用

mysql事件的开启和调用

 

DELIMITER $$

DROP EVENT IF EXISTS CCP_CREATE_TABLE_EVENT $$

CREATE EVENT CCP_CREATE_TABLE_EVENT 

ON SCHEDULE EVERY 1 DAY 

STARTS '2016-12-01 01:00:00'

ON COMPLETION PRESERVE ENABLE

DO

BEGIN

CALL CCP_COLL_LOG_TABLE_DAY(NULL);

CALL CCP_SELF_PERF_TABLE_DAY(NULL);

END $$

DELIMITER ;