什么是事件

一组SQL集，用来执行定时任务，跟触发器很像，都是被动执行的，事件是因为时间到了触发执行，而触发器是因为某件事件（增删改）触发执行；

开启事件

set global event_scheduler = on;

自定义事件

间隔触发

DROP EVENT IF EXISTS `event_del_status`;
DELIMITER ;;
CREATE DEFINER=`root`@`localhost` EVENT `event_del_status` ON SCHEDULE EVERY 1 MINUTE STARTS '2017-01-17 16:17:18' ON COMPLETION NOT PRESERVE ENABLE DO 

BEGIN
    INSERT INTO prooflist(randomcode, email, hashverifycode, verifytype,createtime,count) VALUES ('test1test1test1test1', 'test2test2test2test2', 'test3', 1,current_timestamp(),1);

END
;;
DELIMITER ;

特定事件触发

DROP EVENT IF EXISTS `event_at`;
DELIMITER ;;
CREATE DEFINER=`root`@`localhost` EVENT `event_at` ON SCHEDULE AT '2016-01-17 15:30:00' ON COMPLETION NOT PRESERVE ENABLE DO 

BEGIN
    INSERT INTO USER(name, address,addtime) VALUES('AT','AT',now());
END
;;
DELIMITER ;