万里数据库GreatDB集中式数据库运维之对象管理-9

存储过程

创建存储过程

CREATE
    [DEFINER = user]
    PROCEDURE sp_name ([proc_parameter[,...]])
    [characteristic ...] routine_body

proc_parameter:
    [ IN | OUT | INOUT ] param_name type

type:
    Any valid GREATDB data type

routine_body:
    Valid SQL routine statement

创建一个简单的存储过程:

GreatDB > delimiter //

GreatDB > CREATE PROCEDURE simpleproc (OUT param1 INT)
                 BEGIN
                    SELECT COUNT(*) INTO param1 FROM t;
                 END//
Query OK, 0 rows affected (0.00 sec)

GreatDB > delimiter ;

GreatDB > CALL simpleproc(@a);