Create stored procedure:
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;
Call stored procedure: taxable is true
call ordertotal(20005,1,@total );
SELECT @total;
Call stored procedure: taxable is false
call ordertotal(20005,1,@total);
SELECT @ total;
The above is the content of mysql intelligent stored procedure. For more related content, please pay attention to the PHP Chinese website (m.sbmmt.com)!