title: Copy a MySQL table including indexes
body: <p>I can copy a MySQL table to create a new table:</p>
  
  <pre><code>CREATE TABLE newtable SELECT * FROM oldtable
  </code></pre>
  
  <p>This works, but the indexes are not copied to the new table. How can I copy a table including the indexes?</p>