创建一个存储过程:
create procedure productpricing(
out pl decimal(8,2),
out ph decimal(8,2),
out pa decimal(8,2)
)
begin
select min(prod_price) into pl from products;
select max(prod_price) into ph from products;
select Avg(prod_price) into pa from products;
end;
调用存储过程:
call productpricing(@procelow,@pricehigh,@priceaverage);
select @priceaverage;
删除存储过程:
drop procedure productpricing;
说明:从mysql5添加了对存储过程的支持。