/**查看event是否开启 : show variables like '%event_sche%';将事件计划开启 : set global event_scheduler = 1; 将事件计划关闭 : set global event_scheduler = 0; 关闭事件任务 : alter event eventname on completion preserve disable; 开启事件任务 : alter event eventname on completion preserve enable; 查看事件任务 : show events ;delimiter // 设定语句终结符为 //，因存储过程语句用;结束 **/drop table if exists test; create table test ( id bigint(11) unsigned not null auto_increment, name varchar(100) not null default '', create_time datetime, primary key (id)) engine=innodb auto_increment=1 default charset=utf8;delimiter //drop procedure if exists p_test//create procedure p_test() begin insert into test(name, create_time) values('testname', now());end//drop event if exists e_test//create event e_test on schedule every 10 second starts timestamp '2014-04-09 01:00:00' on completion preserve do begin call p_test();end//
以上事件e_test表示每10秒执行一次p_test()