无法从mysql存储过程中看到任何值

I am using the procedure below : But I am not getting any value when I type this in localhost phpmyadmin/mysql:

我正在使用下面的过程:但是当我在localhost phpmyadmin / mysql中键入它时,我没有得到任何值:

call GetAllProducts() ;

it returns no value as select statement does? where can I execute to see the values? How do I make it wotk.I really appreciate any help. Thanks in Advance.

它不返回select语句的值吗?我在哪里可以执行以查看值?我怎么做它wotk.I真的很感激任何帮助。提前致谢。

The procedure below is successfully executed and stored .I checked that.

下面的过程已成功执行并存储。我检查了一下。

DELIMITER //
CREATE PROCEDURE GetAllProducts()
   BEGIN
   SELECT *  FROM products;
   END //
DELIMITER ;

1 个解决方案

#1

A couple of times you mention using phpMyAdmin; what version do you have?

有几次你提到使用phpMyAdmin;你有什么版本的?

I'm unable to reproduce your problem; it works properly for me. From the database, click the Routines tab, then for your GetAllProducts routine click the Execute link.

我无法重现你的问题;它适合我。在数据库中,单击Routines选项卡,然后在GetAllProducts例程中单击Execute链接。