title: How do I CALL mysql TEMPORARY TABLE from CodeIgniter?
body: <p>I have written a stored procedure in mysql which will create a TEMPORARY TABLE, I want to access the data of TEMPORARY TABLE using Codeigniter.But when I call "$this->db->query()" it returns empty data.</p>
  
  <pre><code>$data=array();
   $call_procedure = "CALL sp_Stock()";
   $query = $this-&gt;db-&gt;query($call_procedure);
   $sql="SELECT * FROM StockTable";
   $query1 = $this-&gt;db-&gt;query($sql);
  </code></pre>