# 将客户端的语句结句定界符换为 |
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> CALL simpleproc(@a)|
Query OK, 0 rows affected (0.00 sec)# 显示结果
mysql> SELECT @a|
+------+
| @a |
+------+
| 3 |
+------+
1 row in set (0.00 sec)更详细的请查看http://www.mysql.com/doc/en/CREATE_PROCEDURE.html
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> CALL simpleproc(@a)|
Query OK, 0 rows affected (0.00 sec)# 显示结果
mysql> SELECT @a|
+------+
| @a |
+------+
| 3 |
+------+
1 row in set (0.00 sec)更详细的请查看http://www.mysql.com/doc/en/CREATE_PROCEDURE.html
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货