mysql create multiple tables

Question

I'm working on a project in which i need to create two tables in one query.

I'm writing like this:

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
);

But this gives an error like "Unknown table 'job'" even if I didn't create it.

Do the tables exist before you try to drop them?

Sean Walsh
– Sean Walsh

2011-11-19 07:27:18 +00:00
Commented Nov 19, 2011 at 7:27 — Sean Walsh
– Sean Walsh, Commented Nov 19, 2011 at 7:27
@Adi, you can also use CREATE TABLE IF NOT EXISTS

Pacerier
– Pacerier

2015-05-08 07:53:23 +00:00
Commented May 8, 2015 at 7:53 — Pacerier
– Pacerier, Commented May 8, 2015 at 7:53

ypercubeᵀᴹ · Accepted Answer · 2011-11-19 07:30:45Z

8

Use the DROP Table IF EXISTS syntax:

Use IF EXISTS to prevent an error from occurring for tables that do not exist.

Something like:

DROP TABLE IF EXISTS
  Employee ;

CREATE TABLE Employee(
...
);

DROP TABLE IF EXISTS
  Job ;

CREATE TABLE Job(
...
);

answered Nov 19, 2011 at 7:30

ypercubeᵀᴹ

116k19 gold badges181 silver badges248 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Authman Apatira · Accepted Answer · 2011-11-19 07:32:23Z

2

You cant drop a table that doesnt exist. Use the:

 DROP TABLE IF EXISTS Job;

answered Nov 19, 2011 at 7:32

Authman Apatira

4,0541 gold badge29 silver badges36 bronze badges

Collectives™ on Stack Overflow

mysql create multiple tables

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related