The structure of the new table is the same as that of the original table, with a few exceptions:
CREATE TABLE … LIKE does not copy foreign key definitions, and it doesn’t
copy any DATA DIRECTORY or INDEX DIRECTORY table options that the table might use.
The new table is empty. If you also want the contents to be the same as the original table,
copy the rows using an INSERT INTO … SELECT statement: