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//
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//
转载于:https://my.oschina.net/chendongj/blog/609382