mysql自帶計劃任務

SET GLOBAL event_scheduler = 1;

delimiter //

drop event if exists `test` //

CREATE EVENT IF NOT EXISTS `test` on schedule every 10 second starts current_timestamp comment '測試事件'

do

 begin

  declare a varchar(255);

declare i int(1) default 0;

DECLARE cur CURSOR FOR select tname from `test`;

OPEN cur;

while i<12 do

FETCH cur INTO a;

insert into `test` (tname) values (a);

set i=i+1;

end while;

close cur;

 end //

delimiter ;

本文轉自 Lee_吉  部落格，原文連結：    http://blog.51cto.com/12173069/1982042    如需轉載請自行聯系原作者