title: StoredProcedure result into a temporary table in MySQL procedure
body: <p>I have a stored procedure/ routine "ABC" which returns me a table with few rows of columns.</p>
  
  <p>In another SP/Routine "XYZ" I want to compare the resultset returned by "ABC" with a table in the db. </p>
  
  <p>But i have hit a roadblock where I am not able to find a way to call the SP "ABC" from within "XYZ". Is there any way I can populate a temporary table by calling "ABC" from "XYZ".</p>
  
  <p>I am very new to MySQL, and am quite sure this is possible in SQL Server and i am now clueless to how i can proceed further. please help me identify where i am making a mistake in understanding my process.</p>