"MySQL" MySQL replication table structure, table data

Normally, copying and backing up tables is usually done directly by the IDE. But sometimes, some initialization of the data script, before operating the data, it is best to back up the structure of the Operation table, data, not error is placed in a dilemma.

So the statement that replicates the table structure and table data comes in handy.

> Copy table structure, table data

Create Table Select *  from t_table_name_2;

> Duplicate table structure

If you just want to copy the table structure, add a condition to filter the data (>_<)

Create Table Select *  from where  - = ;

"MySQL" MySQL replication table structure, table data