mysql - phpMyAdmin - SELECT 语句在存储过程中的结果未显示

Question

我创建了一个简单的程序:

CREATE PROCEDURE  `simpleProcedure` ( IN  `parameter` INT) NOT DETERMINISTIC READS SQL DATA SQL SECURITY DEFINER 
BEGIN
SELECT * 
FROM table1;    
END

在 phpMyAdmin 中使用 CALL simpleProcedure(1) 运行此过程不显示查询结果...如何让 phpMyAdmin 在过程中显示查询结果？

Answer 1

您需要一个OUT 参数才能返回结果，参见http://dev.mysql.com/doc/refman/5.0/en/create-procedure.html .

来自 sakila 数据库的示例:

DELIMITER $$ 
CREATE DEFINER=`root`@`127.0.0.1` PROCEDURE `film_in_stock`(IN p_film_id INT, IN p_store_id INT, OUT p_film_count INT)
    READS SQL DATA 
BEGIN
     SELECT inventory_id
     FROM inventory
     WHERE film_id = p_film_id
     AND store_id = p_store_id
     AND inventory_in_stock(inventory_id);

     SELECT FOUND_ROWS() INTO p_film_count; 
END$$