title: SQL Create multiple tables at once
body: <p>I need to create multiple tables at once. Im having a hard time figuring out the correct method for accomplishing this. Currently my script looks like this:</p>
  
  <pre><code>  private function buildDB() {
      $sql = &lt;&lt;&lt;MySQL_QUERY
  CREATE TABLE IF NOT EXISTS headings (
  type        VARCHAR(150),
  heading     VARCHAR(100),
  uniqueid    VARCHAR(100)
  )
  
  CREATE TABLE IF NOT EXISTS titles (
  type        VARCHAR(150),
  heading     VARCHAR(100),
  uniqueid    VARCHAR(100)
  )
  MySQL_QUERY;
  
      return mysql_query($sql);
    }
  </code></pre>
  
  <p>Obviously, this doesn't work and no tables are created. Is there a simple way for creating multiple tables at once?</p>