mysql 存储过程

CREATE PROCEDURE myproc(OUT s int)
    BEGIN
      SELECT COUNT(*) INTO s FROM students;
    END

带IN参数示例

DROP PROCEDURE IF EXISTS in_param;
DELIMITER //
CREATE PROCEDURE in_param (IN para_in INT)

BEGIN
SELECT * from table1 WHERE age = para_in;
END ;
//DELIMITER

#调用
SET @para_in = 25;

CALL in_param (@para_in);

mysql 存储过程

标签：xxx   rom   tab   存储   div   mysq   table   where   order