mysql 创建事件

工作中使用到了，记录一下

DELIMITER $$
DROP EVENT IF EXISTS event_student_autoarvich;
CREATE EVENT event_student_autoarvich
ON SCHEDULE EVERY 1 DAY
STARTS TIMESTAMP '2017-05-05 00:00:00'
ON COMPLETION PRESERVE
DO
BEGIN
CALL proc_student_autoArchivedTime();
END
$$
DELIMITER