Table replication statements for MySQL and PostgreSQL

In MySQL, copy the existing table structure to a new table:

Method 1:

Create Table custnew1 like MERs MERS;

In this method, only the structure of the table to be copied and the structure of the new table can be used to add new columns while creating the table. However, the new table retains the index structure of the copied table.

 

Method 2:

Create Table custnew2 (ID int auto_increment not null primary key) Select * from MERs MERS;

This method allows you to add new columns, but it does not retain the index structure of the copied table. The preceding statement not only copies the structure of the table to be copied, but also copies the data. If you do not want to copy data, add the 'where' clause:

Create Table custnew2 (ID int auto_increment not null primary key) Select * from MERs where 1 <> 1;

 

Copy an existing table structure in PostgreSQL:

Select * into custnew from MERs where 1 <> 1;

The above statement only copies the table structure. If you want data to come together, delete the WHERE clause. It also does not retain the index.