title: Generate CREATE statements for all MySql Tables
body: <p>I want All <strong>CREATE</strong> statements of MySql Tables in 1 query result.</p>
  
  <p>For example, <strong>INFORMATION_SCHEMA</strong> contains all <em>table names,comments</em> etc. but where are the <strong>CREATE</strong> statements are stored in MySql ? can it be retrieved in one query for all tables ?</p>
  
  <p>Currently i am retrieving <strong>TABLE</strong> ddl as below for 1 table. I have 100's of tables so i can repeat the same everytime which is time taking process</p>
  
  <pre><code>show create table row_format;
  </code></pre>