MYSQLストアドプロシージャタイミング操作データベース
621 ワード
2 , :
create procedure clear_table()
begin
drop database XXX
end
:
event : show variables like '%sche%';
: set global event_scheduler=1;
: alter event e_test ON COMPLETION PRESERVE DISABLE;
: alter event e_test ON COMPLETION PRESERVE ENABLE;
event e_test
CREATE EVENT if not exists e_test
on schedule every 30 second
on completion preserve
do call clear_table();
30S