phpmyadmin run mysql stored procedure but no output

Question

I write a very simple stored procedure as below:

DROP PROCEDURE IF EXISTS GetAllTours;

DELIMITER // 

CREATE PROCEDURE GetAllTours() 

BEGIN 

SELECT * FROM tours; 

END // 

DELIMITER ;

When I use

CALL GetAllTours(); 

from SQL query to run this procedure, there is no output.

But if I run from >>Routines>>Execute, the same procedure, there will have output successfully.

Can anybody tell me how to run from SQL query and get the results?

Answer 1

You can just use this query: CALL GetAllTours