delimiter ;;
create procedure idata()
begin
declare i int;
set i=1;
while(i<=100000)do
insert into t values(i, i);
set i=i+1;
end while;
end;;
delimiter ;
call idata();
Mysql存储过程---while 循环示例
最新推荐文章于 2023-06-15 16:41:34 发布