title: How do I change all tables in my database to use AUTO_INCREMENT=1
body: <p>I have about 30 tables in my database:</p>
  
  <p><code>table1</code> <code>table2</code> <code>table3</code> <code>table4</code> <code>table5</code> etc. </p>
  
  <p>I want all tables to use <code>AUTO_INCREMENT=1</code>, how do I modify the tables?</p>
  
  <p>Here is the sample DDL of one of the tables. I have never defined <code>AUTO_INCREMENT</code> in any of the tables, it is fetching the value by default.</p>
  
  <pre><code>CREATE TABLE `amenities` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `name` varchar(50) NOT NULL,
    PRIMARY KEY (`id`),
    UNIQUE KEY `name` (`name`)
  ) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=8 ;
  </code></pre>