title: MySQL Auto Increment?
body: <p>I have 2 different MySQL servers.
  One is 5.6.12 the other 5.5.25a.</p>
  
  <p>In the 5.5 version server I can do this:</p>
  
  <pre><code>ALTER TABLE AUTO_INCREMENT = 100;
  ALTER TABLE AUTO_INCREMENT = 50;
  </code></pre>
  
  <p>The 5.6 version only allows me to change the auto_increment to a higher value than auto_increment is in that moment.</p>
  
  <p>Of course I'm not trying to change the value to a lower value than the record that has the maximum value.</p>
  
  <p>Both MySQL servers are InnoDB</p>
  
  <p>I need to use that commen in the newest version</p>
  
  <p>Any clue?</p>