title: MySQL: How to insert the result of stored procedure into temporary table
body: <p>I want to insert the results of a stored procedure into a temporary table, like this:</p>
  
  <pre><code>CREATE temporary TABLE NEWBalance (VendorAmount NUMERIC(15,2),   
                                     UserBalanceAmount NUMERIC(15,2));  
  
  INSERT NEWBalance call SP VenAccNo,PeopleId;
  </code></pre>
  
  <p>But that produces an error:</p>
  
  <pre><code>Error Code: 1064. You have an error in your SQL syntax; check 
  the manual that corresponds to your MySQL server version for 
  the right syntax to use near 'call SP VenAccNo,PeopleId' at line 1
  </code></pre>
  
  <p>Is there a way to do this?</p>