title: One SQL query to create multiple tables with same sheet
body: <p>I'm trying to create multiple tables with same sheet in a single query like this</p>
  
  <pre><code> $query ="CREATE TABLE users1, users2, users3 (
      id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
      username VARCHAR(24) NOT NULL UNIQUE,
      password VARCHAR(255) NOT NULL,
      )";
  </code></pre>
  
  <p>then tried to execute it using PDO</p>
  
  <pre><code>$stmt-&gt;execute();
  </code></pre>
  
  <p>but didn't work, Then tried separating them</p>
  
  <pre><code>$query = "CREATE TABLE users1 (
      id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
      username VARCHAR(24) NOT NULL UNIQUE,
      password VARCHAR(255) NOT NULL
      );
  CREATE TABLE users2 (
      id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
      username VARCHAR(24) NOT NULL UNIQUE,
      password VARCHAR(255) NOT NULL
      );
  CREATE TABLE users3 (
      id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
      username VARCHAR(24) NOT NULL UNIQUE,
      password VARCHAR(255) NOT NULL
      );
  ";
  </code></pre>
  
  <p>once with and without the <code>;</code>
  but still give an error</p>