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

MySQL table structure replication, table data migration, temporary table and view creation 1. copy only the table structure, do not copy data www.2cto.com 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 a; Table B originally does not exist: create table B (select a, B, c from a); 3. The syntax for creating a temporary table to create 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 www.2cto.com that belongs to the database: create view test. myView as select a, B from;