1.确保mysqlServcer5.1以上版本
2.CREATE TABLE t ( v VARCHAR(100) NOT NULL ) ENGINE INNODB DEFAULT CHARSET=utf8; //创建表 DELIMITER $$ DROP PROCEDURE IF EXISTS e_test $$ CREATE PROCEDURE e_test() BEGIN INSERT INTO t VALUES('1'); END $$ DELIMITER ; //写语句 SHOW VARIABLES LIKE '%sche%'; //查看定时器是开启还是关闭 SET GLOBAL event_scheduler = 1; CREATE EVENT IF NOT EXISTS event_test ON SCHEDULE EVERY 1 DAY STARTS TIMESTAMP '2015-06-08 22:10:00' DO CALL e_test(); //从2015-06-08 22:10:00'开始执行 ALTER EVENT event_test ON COMPLETION PRESERVE ENABLE;//开启定时任务 ALTER EVENT event_test ON COMPLETION PRESERVE DISABLE; //关闭定时任务