存储过程、定时事件的使用

存储过程

create procedure del_data()

begin

-- 执行的sql

  delete from mmdbi.dianshang where date_key=date_format(curdate(),'%Y%m');

end

定时事件

create event del_event

on schedule

EVERY 1 day

STARTS '2014-01-01 03:00:00'

ON COMPLETION PRESERVE ENABLE

do call del_data()

关闭事件任务: alter event del_event ON COMPLETION PRESERVE DISABLE;

开户事件任务: alter event del_event ON COMPLETION PRESERVE ENABLE;

show events

查看event是否开启: show variables like '%sche%';

将事件计划开启: set global event_scheduler = ON;