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, Jul 09 '15 at 19:45
possible duplicate of [SELECT INTO and "Undeclared variable" error](http://stackoverflow.com/questions/2949653/select-into-and-undeclared-variable-error) — jpw, Jul 09 '15 at 19:47

Fin Dev · Answer 1 · 2015-07-09T19:53:52.923

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 09 '15 at 19:53

answered Jul 09 '15 at 19:49

Fin Dev

309
2
8

edited to include create table syntax, if table doesn't exist – Fin Dev Jul 09 '15 at 19:54

score 0 · Answer 2 · answered Jul 09 '15 at 19:53

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

MySQL Copying tables

2 Answers2