检查MySql数据库版本:select VERSION() ;//MySql在5.1以后才支持事务
检查事务是否开启:
show VARIABLES LIKE '%sche%';
开启事务: set global event_scheduler =1;
检查事务是否开启:
show VARIABLES LIKE '%sche%';
关闭事务:
alter event e_test ON COMPLETION PRESERVE DISABLE;
对已关闭的事务重新开启:
alter event e_test ON COMPLETION PRESERVE ENABLE;
一般定时执行有2种:
1、从具体一个时间点开始,每隔一段时间执行一次;
从现在开始,每30秒执行一次
create event if not exists e_test
on schedule every 30 second starts now()
on completion preserve
do
INSERT into sdb_yoyi (yoyiscid,orderid) VALUES(2,3)
2、从具体一个时间点开始,在当日的某个时间点进行执行;
每个月的一号凌晨1点执行
create event if not exists e_test2
on schedule every 1 month starts DATE_ADD(DATE_ADD(DATE_SUB(CURDATE(),INTERVAL DAY(CURDATE())-1 DAY), INTERVAL 1 MONTH),INTERVAL 1 HOUR)
on completion preserve
do
INSERT into sdb_yoyi (yoyiscid,orderid) VALUES(2,3)