mysql智能存储过程

来源：动视网责编：小采时间：2020-11-09 09:14:09

mysql智能存储过程

mysql智能存储过程:创建存储过程： CREATE procedure ordertotal( in onumber int, in taxable boolean, out ototal decimal(8,2) ) COMMENT 'Obtain order total,optionally adding tax' begin DECLARE tota

推荐度：

点击下载本文 文档为doc格式

导读mysql智能存储过程:创建存储过程： CREATE procedure ordertotal( in onumber int, in taxable boolean, out ototal decimal(8,2) ) COMMENT 'Obtain order total,optionally adding tax' begin DECLARE tota

创建存储过程：

 CREATE procedure ordertotal(
in onumber int, 
in taxable boolean, 
out ototal decimal(8,2) 
) COMMENT 'Obtain order total,optionally adding tax'
begin
DECLARE total decimal(8,2); 
declare taxrate int DEFAULT 6; 
SELECT sum(item_price * quantity) from orderitems where order_num = onumber into total; 
if taxable then 
SELECT total+(total/100*taxrate) into total; 
end if; 
SELECT total into ototal;

end;

调用存储过程：taxable为真

call ordertotal(20005,1,@total);

SELECT @total;

调用存储过程：taxable为假

call ordertotal(20005,1,@total);

SELECT @total;