mysql自带计划任务

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 ;

mysql自带计划任务

标签：mysql