Duplicating a MySQL table, indexes and data -

How do I copy / copy the data, structure and index of a MySQL table?

It has been found so far.

This will copy the data and structure, but the index will not be:

  create table {new_table}, select {old_table} from *;  

This will make a copy of the structure and indexed, but not the data:

  to create the table {new_table} such as {old_table};  

Ask these 2 questions to copy from indexes and triggers:

  create new tablettable tablets; Choose new tablet * from old;  

To make a copy of just the structure and data, use one:

  Create a tablet as tbl_new * to tbl_old;  

I have asked before: