drop procedure if exists pre;
create procedure pre()
begin
declare i int;
set i=1;
while i<100 do
insert into user(id,name,sex,age)
values(i,concat('马云',i),'男',ceiling(rand()*90+10));
set i=i+1;
end while;
end
//调用
call pre();