MySQL table structure replication, table data migration, and temporary table and view Creation

1. Only copy the table structure without copying data

Select * into B from a where 1 <> 1;

 

2. Table data migration table B already exists:

Insert into B (d, e, f) Select a, B, c from;

Table B originally does not exist:

Create Table B (select a, B, c from );

 

3. Create a temporary table

The syntax for creating a temporary table is very simple. If the temporary table is in memory, the session ends and disappears:

Create temporary Table (...);

 

4. Create a view

Views belong to databases:

Create view test. myview as select a, B from;