将10元随机分成三个红包，红包金额保留两位小数。

不需要将结果保存到数据表中，使用select展示结果即可 create procedure hongbao()
begin
 declare n int default 1000;
 declare b1 int;
 declare b2 int;
 declare b3 int;
 
 declare r1 double;
 declare r2 double;
 declare r3 double;
 declare sum double;
 
 set r1 =rand();
 set r2 =rand();
 set r3 =rand();
 
 set sum = r1+r2+r3;
 
 set b1 = TRUNCATE((r1/sum)*n,0);
 set b2 = TRUNCATE((r2/sum)*n,0);
 set b3 = TRUNCATE((r3/sum)*n,0);
 
 select b1/100,b2/100,b3/100;
end;
call hongbao;