创建存储过程

建存储过程：total_order(IN orderid INT , OUT totals NUMERIC(9,2), OUT cid INT)

要求：根据输入的订单编号(order_id)，返回订单总金额(total_money),顾客编号(customer_id)。

CREATE PROCEDURE total_order (
  IN orderid INT,
  OUT totals NUMERIC (9, 2),
  OUT cid INT
) 
SELECT 
  total_money,
  customer_id INTO totals,
  cid 
FROM
  orders 
WHERE order_id = orderid ;

建立存储过程show_grade：根据学号，课程名参数，返回学生的成绩。

CREATE PROCEDURE show_grade (
  IN sno1 CHAR(7),
  IN cname1 VARCHAR (20),
  OUT grade1 SMALLINT
) 
SELECT 
  grade INTO grade1 
FROM
  sc,
  course 
WHERE sc.cno = course.cno 
  AND cname = cname1 
  AND sno = sno1 ;