title: Execute multiple semi-colon separated query using mysql Prepared Statement
body: <p>I am trying to create a stored procedure in mysql which creates a new table on every request copies the content from another table and extracts the required data and finally drops the table. The stored procedure is quite large so I cant have EXECUTE after every query and thus I am trying to execute the query all together in a semicolon separated format. But on final execution I get Error Code: 1064.
  Is the approach I am trying possible, or is there a better approach.</p>
  
  <pre><code>SET tableName = (SELECT CONCAT("table",(UNIX_TIMESTAMP(NOW()))));
  
  SET @tquery =CONCAT('CREATE TABLE `',tableName,'` (select pt.* from post_table pt join on user u on pt.user_id=u.id where pt.client="client",pt.group="group");');
  SET @tquery = CONCAT(@tquery,' SELECT * FROM ',tableName,';');    
  SET @tquery = CONCAT(@tquery,' DROP TABLE ',tableName,';');    
  PREPARE stmt FROM @tquery;
  EXECUTE stmt;
  DEALLOCATE PREPARE stmt;  
  </code></pre>