title: mysql create multiple tables
body: <p>I'm working on a project in which i need to create two tables in one query.</p>
  
  <p>I'm writing like this:</p>
  
  <pre><code>DROP TABLE Employee;
  
  CREATE TABLE Employee(
  Employee_Id CHAR(12)NOT NULL PRIMARY KEY,
  First_name CHAR(30),
  Last_name CHAR(30),
  Address VARCHAR(50),
  City CHAR,
  State CHAR,
  Salary INT,
  Gender CHAR,
  Age INT
  );
  
  DROP TABLE Job;
  
  CREATE TABLE job(
  Exempt_Non_Exempt_Status tinyint(1) NOT NULL PRIMARY KEY,
  Job_title CHAR,
  Job_description CHAR
  ); 
  </code></pre>
  
  <p>But this gives an error like "Unknown table 'job'" even if I didn't create it.</p>