title: MySQL SHOW CREATE TABLE parameters?
body: <p>I am using the <code>SHOW CREATE TABLE</code> command to get a create code for my table. However, I noticed that the create command is missing a few features.</p>
  
  <p>For instance, it doesn't have an <code>IF NOT EXISTS</code> parameter. It also lists the <code>AUTO_INCREMENT=#</code> position at the end; which isn't really needed since its an auto increment.</p>
  
  <p>Is there any way to add parameters to the query to fix these issues?</p>