delimiter //
create procedure myproc()
begin
declare num int;
set num=1;
while num < 10 do
insert into t_tag(tag_name, tag_desc) values(concat(“tag”, num), concat(“tag”, num)); set num=num+1;
end while;
end//
创建存储过程
最新推荐文章于 2023-06-15 07:27:50 发布