存储过程

CREATE  PROCEDURE  num_from_employee (IN emp_id INT, OUT count_num INT )
          READS SQL DATA                      （这里的可以是：{ CONTAINS SQL | NO SQL | READS SQL DATA | MODIFIES SQL DATA }）
          BEGIN
              SELECT  COUNT(*)  INTO  count_num
              FROM  employee
              WHERE  d_id=emp_id ;

          END