MySQL Copying tables

Question

I have an empty template table called Table1. I want to copy this table multiple times so I can have Table2 Table3 Table4 and so on, including the fields.

I have tried:

SELECT *
INTO Table2
FROM Table1

but I keep getting this error:

ERROR 1327 (42000): Undeclared variable: Table2

Am I doing this wrong?

CREATE TABLE table2 AS SELECT * FROM table1; might work better for you. — Norbert
– Norbert, Commented Jul 9, 2015 at 19:45
possible duplicate of SELECT INTO and "Undeclared variable" error — jpw
– jpw, Commented Jul 9, 2015 at 19:47

Fin Dev · Accepted Answer · 2015-07-09 19:53:52Z

1

If table doesn't exist do:

CREATE TABLE table2 LIKE table1;

After table is created do:

INSERT INTO table2 SELECT * FROM table1;

edited Jul 9, 2015 at 19:53

answered Jul 9, 2015 at 19:49

Fin Dev

3092 silver badges8 bronze badges

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

1 Comment

Fin Dev Over a year ago

edited to include create table syntax, if table doesn't exist

Ike Walker · Accepted Answer · 2015-07-09 19:53:52Z

0

Since you said Table1 is empty you can create an identical empty table called Table2 like this:

create table table2 like table1

If Table1 has data in it and you want to copy the data as well, then you can do this:

create table table2 as select * from table1

answered Jul 9, 2015 at 19:53

Ike Walker

65.8k14 gold badges115 silver badges112 bronze badges

Collectives™ on Stack Overflow

MySQL Copying tables

2 Answers 2

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related