delimiter
create PROCEDURE pre()
begin
declare i int;
set i=0;
while i<=10000 do
insert into temp(id, name, pwd ) values(0, concat('策是', i), concat('123', i));
set i=i+1;
end while;
end
//调用
call pre()