mysql ????????
???????????? ???????[ 2016/7/6 15:43:01 ] ????????????? MySQL
????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;
??????
???·???
??????????????????
2023/3/23 14:23:39???д?ò??????????
2023/3/22 16:17:39????????????????????Щ??
2022/6/14 16:14:27??????????????????????????
2021/10/18 15:37:44???????????????
2021/9/17 15:19:29???·???????·
2021/9/14 15:42:25?????????????
2021/5/28 17:25:47??????APP??????????
2021/5/8 17:01:11