[b]检测事件是否开启[/b]
show variables like 'event_scheduler';
[img]http://files.jb51.net/file_images/article/201501/2015010811122410.jpg[/img]
[b] 2.开启事件[/b]
set global event_scheduler = on;
[b] 3.创建一个存储过程[/b]
delimiter //
create procedure test()
begin
update project set create_time = now();
end;
[b] 4.创建一个事件[/b]
create event if not exists e_test
on schedule every 30 second
on completion preserve
do call test();
[b] 5.关闭或开启执行事件[/b]
alter event event_name on completion preserver [enable | disable]
[b] 6.删除事件[/b]
drop event event_name;
机械节能产品生产企业官网模板...
大气智能家居家具装修装饰类企业通用网站模板...
礼品公司网站模板
宽屏简约大气婚纱摄影影楼模板...
蓝白WAP手机综合医院类整站源码（独立后台）...
