create procedure hongbao()
begin
declare m int default 1000;
declare m1 int ;
declare m2 int ;
declare m3 int ;
declare r double;
declare r1 double;
declare r2 double;
declare r3 double;
set r1=rand();
set r2=rand();
set r3=rand();
set r=r1+r2+r3;
set m1=truncate((r1/r)*m,0);
set m2=truncate((r2/r)*m,0);
set m3= m-m1-m2;
select m1/100,m2/100,m3/100;
end
call hongbao();