mysql 存储过程

delimiter //
create procedure myproc()
begin
declare num int;
set num=1;
while num < 100 do
insert into t_tag(value1, value2) values(concat("value", num), concat("value", num)); set num=num+1;
end while;
end//