摘要: 查看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;简单实例.创建表 CREATE TABLE test(endtime DATETIME);创建存储过程testCREATE PROCEDURE test ()BEGINupdate examin 阅读全文
posted @ 2013-04-19 17:58 流星焱雨 阅读(428) 评论(0) 推荐(0) 编辑