title: MySQL Create table with procedure analyze()
body: <p>Procedure Analyse() suggests the optimal field for my columns. I want to create a new table with optimal field types starting from a table that I already have. At this time I'm running </p>
  
  <pre><code>SELECT * FROM mytable PROCEDURE ANALYSE();
  </code></pre>
  
  <p>Then I copy the report and manually I write the create statement. Is there a way to do that automatically? Is it more efficient to alter a table with new field types or create a new empty table with optimal field types and re-import data?</p>