从select语句mysql调用用户定义的存储过程 [英] Calling a user defined stored procedure from select statement mysql

问题描述

我正在尝试从select语句调用用户定义的存储过程，这给了我一个错误.但是，当我调用系统过程时，它就可以正常工作.有没有一种方法可以从select语句中调用用户定义的过程.这是针对mysql

I am trying to call a user defined stored procedure from a select statement and its giving me an error. However when I call a system procedure it works just fine. Is there a way to call a user defined procedure from a select statement. This is for mysql

SELECT ID, email FROM user PROCEDURE simpleproc();

给我一​​个错误ERROR 1106(42000):未知过程'simpleproc'

give me an error ERROR 1106 (42000): Unknown procedure 'simpleproc'

mysql> call simpleproc();

查询正常，受影响的0行(0.21秒)

Query OK, 0 rows affected (0.21 sec)

与

SELECT ID, email FROM user PROCEDURE ANALYSE();

有效

推荐答案

您可以从select语句中调用存储过程，要调用该过程，必须使用以下语法:

You can call stored procedure from select statement,To call a procedure you must use following syntax:

CALL stored_procedure_name (param1, param2, ....)  

例如，您可以拨打以下电话号码:

Such as, you can CALL following procedure:

DELIMITER //

CREATE PROCEDURE `procedure1`(IN var1 INT)
BEGIN
    SELECT var1 + 2 AS result;
END//

为

CALL procedure1(10);

检查此站点以供参考: http://net. tutsplus.com/tutorials/an-introduction-to-stored-procedures/

Check this site for reference: http://net.tutsplus.com/tutorials/an-introduction-to-stored-procedures/

这篇关于从select语句mysql调用用户定义的存储过程的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！