芝麻谷子-存储过程定时执行实例

delimiter $
use zhimaguzi;
create procedure linqipin()
begin
update zhi_w_something set is_linqipin = 1 where CURRENT_TIMESTAMP() > linqipintime;
end$
CREATE EVENT if not exists linqipin_hourly
ON SCHEDULE EVERY 600 second
COMMENT ‘check linqinpin.’
DO call linqipin()$