mysql 创建event 相当于job

DROP EVENT IF EXISTS `e_del_tbl_base_count`;
DELIMITER ;;
CREATE EVENT `e_del_tbl_base_count`  
ON SCHEDULE EVERY 1 DAY STARTS '2016-06-23 17:33:43'  
ON COMPLETION NOT PRESERVE ENABLE
DO CALL sum_Customer;
每一天执行一次

DROP EVENT IF EXISTS `Clear_Expire_Token`;
CREATE  EVENT `Clear_Expire_Token`
ON SCHEDULE EVERY 10 MINUTE STARTS '2016-07-20 13:42:07'
ON COMPLETION PRESERVE ENABLE
DO call Sp_Clear_Expire_Token;
每10分钟执行一次

当为on completion preserve 的时候,当event到期了,event会被disable,但是该event还是会存在
当为on completion not preserve的时候,当event到期的时候,该event会被自动删除掉.