题目:一球从100米高度自由落下,每次落地后反跳回原高度的一半;再落下,求它在第10次落地时,共经过多少米?第10次反弹多高?
drop PROCEDURE if exists test;
create PROCEDURE test ( )
begin
declare h,s DOUBLE;
declare i int DEFAULT 2;
set h=100,s=100;
set h=h/2;
while i<=10 do
set s=s+2*h;
set h=h/2;
set i=i+1;
end while;
select s,h;
end;