id int primary key , age int , name varchar(18) );
创建存储过程
create procedure sp_name()
begin
declare i...int default 0;
start transaction;
while i<10000000 do
insert into t(id,age,name)values(i,i,'zhangsan'...);
set i=i+1;
end while;
commit;
end;
调用存储过程
call sp_name();
删除存储过程
drop procedure sp_name;
注意事项
1)...不能在一个存储过程中删除另一个存储过程,只能调用另一个存储过程
使用示例:
create procedure sp_name()
begin
declare i int default 0;
start...transaction;
while i<10000000 do
insert into t(id,age,name)values(i,i,'zhangsan');
set i=i+1;
end while