create procedure generate_equipment(district int,warehouseno varchar(10) )
begin
declare l_no varchar(50);
declare l_address varchar(20) ;
declare l_name varchar(20) ;
declare l_city varchar(20) default 天津;
declare l_longitude double;
declare l_latitude double;
declare l_money bigint;
declare l_type tinyint default 2;
declare l_rand double;
declare l_init long;
declare l_actual long;
declare i int default 0;
while i select longitude into l_longitude from warehouse where no=warehouseno and district=district;
select latitude into l_latitude from warehouse where no=warehouseno and district=district;
set l_address=address;
set l_name=equipment;
set l_rand=rand();
set l_no=concat('03q',round(l_rand*1000000000000));
set l_address=concat(l_address,round(l_rand*i));
set l_name=concat(l_name,round(l_rand*i));
set l_longitude=l_longitude+l_rand;
set l_latitude=l_latitude+l_rand;
set l_init=round(l_rand*30000);
set l_actual=round(l_rand*13000);
insert into equipment (no,name,city,district,address,longitude,latitude,init,actual,type) values(l_no,l_name,l_city,district,l_address,l_longitude,l_latitude,l_init,l_actual,l_type);
set i=i+1;
end while;
end;
$
delimiter ;