#1、创建evevt要调用的存储过程update_current_value_proceduredelimiter //drop procedure if exists update_current_value_procedure//create procedure update_current_value_procedure()begin update xw_sequence set CURRENT_VALUE=1 where SEQ_NAME= 'group_id_seq';end//delimiter ;#2、创建事件update_current_value_eventdrop event if exists update_current_value_event;create event update_current_value_eventON SCHEDULE EVERY 1 DAY STARTS '2017-05-08 00:00:00'on completion preserve disabledo call update_current_value_procedure();#3、开启事件update_current_value_eventalter event update_current_value_event on completion preserve enable;