Full table replication for two mysql tables

This is a simple article that uses SQL statements to copy data from one table to another. If you need it, refer to it.

Reputation: a and B are both tables -- B tables exist (the two tables have the same structure)

Insert into B select * from a if only some of the two tables (fields) are the same, insert into B (col1, col2, col3, col4 ,...) select col1, col2, col3, col4 ,... from a where... insert table a into Table B.

-- Table B does not exist
Select * into B from

// Select (Field 1, Field 2,...) into B from