Mysql Table copy: Create table like and create table as Select_mysql

Copy Code code as follows:

CREATE TABLE A like B

This way, when you copy table B to a, the complete field structure and index of table B are copied into table A.

Copy Code code as follows:

CREATE TABLE A as SELECT x,x,x,xx from B LIMIT 0

This way only copies the field structure of Table B to table A, but does not replicate the index in table B to table A. This is a more flexible way to specify which fields to replicate while copying the original table structure, and also to add the field structure as needed.

There are two ways to copy a table without copying the permissions to the table's settings. For example, if you have permissions set on table B, after copying, table A does not have permissions similar to Table B.

Leave blank, and then explore the performance of two replication tables