mysql循环插入记录例子

delimiter //

create procedure myproc() 
begin 
declare num int; 
set num=1; 
while num < 10 do 
insert into STORE(tag_name, tag_desc) values(concat("tag", num), concat("tag", num)); set num=num+1;
end while;
 end//