#创建存储过程
delimiter $$
create procedure zqtest()
begin
declare i int default 0;
set i=0;
start transaction;
while i<80000 do
insert into student(user_id) VALUES(CONCAT(1101,i));
set i=i+1;
end while;
commit;
end
$$
#调用存储过程
call zqtest();
01-30
170
![](https://csdnimg.cn/release/blogv2/dist/pc/img/readCountWhite.png)
02-28
1007
![](https://csdnimg.cn/release/blogv2/dist/pc/img/readCountWhite.png)
01-10
4259
![](https://csdnimg.cn/release/blogv2/dist/pc/img/readCountWhite.png)
09-22