title: phpmyadmin run mysql stored procedure but no output
body: <p>I write a very simple stored procedure as below:</p>
  
  <pre><code>DROP PROCEDURE IF EXISTS GetAllTours;
  
  DELIMITER // 
  
  CREATE PROCEDURE GetAllTours() 
  
  BEGIN 
  
  SELECT * FROM tours; 
  
  END // 
  
  DELIMITER ;
  </code></pre>
  
  <p>When I use  </p>
  
  <pre><code>CALL GetAllTours(); 
  </code></pre>
  
  <p>from SQL query to run this procedure, there is no output. </p>
  
  <p>But if I run from <code>&gt;&gt;Routines&gt;&gt;Execute</code>, the same procedure, there will have output successfully.</p>
  
  <p>Can anybody tell me how to run from SQL query and get the results?</p>