MySQL table copy: Create table like vs. create table as Select

CREATE TABLE A like B

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

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

This method only copies the field structure of Table B to table A, but does not copy the index from table B to table A. This is a flexible way to specify which fields you want to replicate while replicating the original table structure, and you can also add the field structure as needed by copying the table itself.

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

Via:http://www.jb51.net/article/58940.htm

MySQL table copy: Create table like vs. create table as Select