mysql创建表另一个表_在MySQL中创建与另一个表匹配的表？

Use LIKE to create an empty table based on the definition of another

table, including any column attributes and indexes defined in the

original table:

CREATE TABLE new_table LIKE original_table; The copy is created using the same

version of the table storage format as the original table. The SELECT

privilege is required on the original table.

LIKE works only for base tables, not for views.

CREATE TABLE … LIKE does not preserve any DATA DIRECTORY or INDEX DIRECTORY table options that were specified for the original table, or any foreign key definitions.