这个涉及2个步骤，第一个就是建立存储过程：create procedure clear_table()begin   drop database XXXend第二步就是让其定时运行：查看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