SQL: copy a table into another... Solved

Question

Hello everyone,

The query:
CREATE TABLE TABLE2 AS SELECT * FROM TABLE1 ;
allows me to copy the structure as well as the data from TABLE1 into TABLE2.
Is there a way (query) to copy only the structure (without the data)?

Thank you all for your help.

Lio · Accepted Answer

Even cleaner:  CREATE TABLE table2 LIKE table1  (Simply copies the structure of table1 by creating table2)

yanban · Answer

if :  CREATE TABLE TABLE2 AS SELECT * FROM TABLE1 where 1=2

Nico · Answer

Awesome... Thanks yanban.

drizzt40 · Answer

It's funny, I was thinking of creating the structure with the data and then deleting the content of the table.... We need to learn to simplify our lives..... ;)  =}- The_Str@nger -{=

doanvhay · Answer

Hello,  Once the empty table2 is created, how can it be copied to give it to a third party?

nubian110 · Answer

Thank you very much, it's beautiful, "Simplicity is an art"!!!

Syls · Answer

Hello,  the where clause just returns a bool.  So, something like:  SELECT * INTO TABLE2 FROM TABLE1 WHERE 1=0  should "create" the structure without returning any data.  Syls

Syls · Answer

Even a little cleaner:  SELECT * INTO TABLE2 FROM TABLE1 WHERE FALSE

Noum77 · Answer

I have this for the structure only; but you'll need to try it because I haven't had the time yet:  CREATE TABLE table1_copy LIKE mabase.table1;

SQL: copy a table into another...

9 answers

Choosing an email address from a site submission

Enigmes père fourasse

Sms, how to insert a blank line between two paragraphs

Shoddy update

Reviews on the vipmontres website

Tiny11 installation

Blocked phone asks for an emergency code

Saving attachments on personal site

Command disappears immediately

Compromised zimbra email account