创建存储程序和函数_MySQL

来源：懂视网责编：小采时间：2020-11-09 20:02:18

创建存储程序和函数_MySQL

创建存储程序和函数_MySQL:CREATE PROCEDURE和CREATE FUNCTIONmysql> delimiter // mysql> CREATE PROCEDURE simpleproc (OUT param1 INT) -> BEGIN -> SELECT COUNT(*) INTO param1 FROM t; -> END -> //Query OK, 0 row

推荐度：

点击下载本文 文档为doc格式

导读创建存储程序和函数_MySQL:CREATE PROCEDURE和CREATE FUNCTIONmysql> delimiter // mysql> CREATE PROCEDURE simpleproc (OUT param1 INT) -> BEGIN -> SELECT COUNT(*) INTO param1 FROM t; -> END -> //Query OK, 0 row

CREATE PROCEDURE和CREATE FUNCTION

mysql> delimiter //

mysql> CREATE PROCEDURE simpleproc (OUT param1 INT)

-> BEGIN

-> SELECT COUNT(*) INTO param1 FROM t;

-> END

-> //

Query OK, 0 rows affected (0.00 sec)

mysql> delimiter ;

mysql> CALL simpleproc(@a);

Query OK, 0 rows affected (0.00 sec)

mysql> SELECT @a;