How a MySQL database can quickly replicate tables and data in a table

1.COPY table Structure

SHOW CREATE table runoob_tbl; (Select the table you want to copy),
Copy its creation statement, execute can create table structure of the same table, remember to change the name Oh.

2.copy table Data

Select the field you want to insert data from in the table you created, and then query it from the table you want to copy.

Refresh, Ok.

Insert into Mytable10 (id,username) select Id,username from Mytable1;

How a MySQL database can quickly replicate tables and data in a table