title: Return Multiple Result Sets from MYSQL Stored Procedure
body: <p>How do you return multiple result sets from a MYSQL Stored Procedure?</p>
  
  <p>This is my test stored proc:</p>
  
  <pre><code>DELIMITER $$
  
  CREATE DEFINER=`hlamAdmin`@`%` PROCEDURE `test`()
  BEGIN
     SELECT *
     FROM hlam.member;
  
     SELECT * 
     FROM hlam.security;
  
  END
  </code></pre>
  
  <p>Now when I call this:</p>
  
  <pre><code>Call test()
  </code></pre>
  
  <p>I only receive one resultset. How do I receive both? I am used to MSSQL I apologize if this is an easy question. </p>