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 ;