mysql 存储过程:输出参数 [英] mysql stored-procedure: out parameter

问题描述

我有一个 mysql 存储过程(google book)，一个例子是这样的:

I have a mysql stored procedure from this (google book), and one example is this:

DELIMITER $$

DROP PROCEDURE IF EXISTS my_sqrt$$
CREATE PROCEDURE my_sqrt(input_number INT, OUT out_number FLOAT)
BEGIN
    SET out_number=SQRT(input_number);
END$$

DELIMITER ;

程序编译良好.(我在 ubuntu 中使用 MySQL 查询浏览器).

The procedure compiles fine. (I am using MySQL Query Browser in ubuntu).

但是当我调用程序时:

CALL my_sqrt(4,@out_value);

(也在查询浏览器中)

它返回一个错误:

(1064) check the manual that correspond to the...

为什么这个例子不起作用?

Why isn't this example working?

推荐答案

无法复制.对我来说效果很好:

Unable to replicate. It worked fine for me:

mysql> CALL my_sqrt(4, @out_value);
Query OK, 0 rows affected (0.00 sec)

mysql> SELECT @out_value;
+------------+
| @out_value |
+------------+
| 2          | 
+------------+
1 row in set (0.00 sec)

也许您应该粘贴整个错误消息而不是总结它.

Perhaps you should paste the entire error message instead of summarizing it.

这篇关于mysql 存储过程:输出参数的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！