菜鸟级别存储过程mysql

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;  //关闭定时任务