不需要将结果保存到数据表中,使用select展示结果即可
create procedure bian()
begin
DECLARE x DOUBLE;
DECLARE y DOUBLE;
DECLARE z DOUBLE;
DECLARE ji DOUBLE;
DECLARE n int DEFAULT 1000;
set x=RAND();
set y=RAND();
set z=RAND();
set ji=x+y+c
set x=TRUNCATE(x/ji*n,2)/100
set y=TRUNCATE(y/ji*n,2)/100
set z=TRUNCATE(z/ji*n,2)/100
SELECT x,y,z
end;
call bian();