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会被自动删除掉.
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会被自动删除掉.