start transaction; //开启服务
create procedure getData()
begin
declare i int; 创建存储过程
set i=0;
while i<3000 do
insert into `p_employee`(name,departmentId) values("xx",1); 插入数据
set i=i+1;
end while;
end;
CALL getData(); //调用存储过程
DROP PROCEDURE getData; //删除存储过程
create procedure getData()
begin
declare i int; 创建存储过程
set i=0;
while i<3000 do
insert into `p_employee`(name,departmentId) values("xx",1); 插入数据
set i=i+1;
end while;
end;
CALL getData(); //调用存储过程
DROP PROCEDURE getData; //删除存储过程