Scenario 1
1.1
Copy entire table (with data, no primary key index): old_table--->new_table
CREATE TABLE new_table SELECT * from old_table;
1.2
Copy entire table structure (no data, no primary key index): old_table--->new_table
CREATE TABLE new_table SELECT * from old_table where 0;
Scenario 2
2.1
Copy entire table structure (no data, with primary key index): old_table--->new_table
CREATE TABLE new_table like old_table
2.2
Copy entire table (with data, no primary key index)
CREATE TABLE new_table (SELECT * from old_table)
Scenario 3
3.1
Copy entire table (with data, primary key, index)
CREATE TABLE new_table like old_table;
INSERT into new_table SELECT * from old_table;
If it is not an entire table copy or cross-database operation, you can change the select * from Old_table;
For example:
INSERT into new_table SELECT Username,password from old_table;
CREATE TABLE new_db.new_table like old_db.old_table;
Database: Table structure and data replication instance
