Create Table Issue in MySql

Question

I am creating table in MySql by using the coomand, create table person ( id int, name int). Actually, I want to create table person if there exists no person table in database. Can anybody help me, how to acive this ?

This might help: stackoverflow.com/questions/84330/…

Dan
– Dan

2012-02-02 22:23:47 +00:00
Commented Feb 2, 2012 at 22:23 — Dan
– Dan, Commented Feb 2, 2012 at 22:23
Or this: stackoverflow.com/questions/9069179/…

thursdaysgeek
– thursdaysgeek

2012-02-02 22:40:33 +00:00
Commented Feb 2, 2012 at 22:40 — thursdaysgeek
– thursdaysgeek, Commented Feb 2, 2012 at 22:40

Managu · Accepted Answer · 2012-02-02 22:23:42Z

4

How about CREATE TABLE IF NOT EXISTS person (id INT, name INT)?

answered Feb 2, 2012 at 22:23

Managu

9,0892 gold badges32 silver badges36 bronze badges

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

Comments

Joachim Isaksson · Accepted Answer · 2012-02-02 22:23:51Z

2

The manual page says that you should use

CREATE TABLE IF NOT EXISTS person (id int, name int);

answered Feb 2, 2012 at 22:23

Joachim Isaksson

182k28 gold badges298 silver badges308 bronze badges

Comments

jcmeloni · Accepted Answer · 2012-02-02 22:25:09Z

2

CREATE TABLE IF NOT EXISTS person (id int, ...);

See manual.

answered Feb 2, 2012 at 22:25

jcmeloni

1,2341 gold badge15 silver badges21 bronze badges

Comments

peterept · Accepted Answer · 2012-02-02 22:26:42Z

1

Use IF NOT EXISTS:

create table if not exists person ( id int, name int).

See MySQL documentation

answered Feb 2, 2012 at 22:26

peterept

4,42727 silver badges33 bronze badges

Collectives™ on Stack Overflow

Create Table Issue in MySql

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related