????1?????????evevt?????????
????show variables like 'event_scheduler'
????2??????????
????SET GLOBAL event_scheduler = 1;
?????????SET GLOBAL event_scheduler = 'no';
????3??????????????
????drop table if exists test;
????create table test
????(
????id int(11) not null auto_increment primary key??
????time datetime not null
????) engine=innodb default charset=utf8;
????4??????evevt???????е?洢????
????delimiter //
????drop procedure if exists delete_resource_order_proce //
????create procedure delete_resource_order_proce()
????begin
????insert into test(time) values(now());
????end //
????delimiter;
????5???????????е????
????drop event if exists delete_resource_order_event;
????create event delete_resource_order_event
????on schedule every 1 DAY STARTS '2016-07-06 00:00:00'
????on completion preserve disable
????do call delete_resource_order_proce();
????6?????????delete_resource_order_event
????alter event delete_resource_order_event on completion preserve enable;
????7????????delete_resource_order_event
????alter event delete_resource_order_event on completion preserve disable;