一个事件,对应一个存储过程
//创建一个事件
CREATE EVENT `xxx`.`times_event`
ON SCHEDULE EVERY 1 DAY
STARTS '2015-09-29 00:00:00' ON COMPLETION PRESERVE
ENABLE
DO begin
call times_control();
end
//创建一个存储过程
CREATE PROCEDURE `xxx`.`times_control` ()
NOT DETERMINISTIC
SQL SECURITY DEFINER
begin
update summer_user_info set play_times = 3 where play_times<3;
end;