title: MySQL Auto Increment Values After DELETE without WHERE
body: <p>I noticed after running,</p>
  
  <pre><code>DELETE FROM tablename
  </code></pre>
  
  <p>My ID (auto increment) values became weird </p>
  
  <pre><code>7, 8, 9, 0, 1, 12, 3, 4, 15 
  </code></pre>
  
  <p>In this order when I do a,</p>
  
  <pre><code>SELECT * FROM tablename
  </code></pre>
  
  <p>I know that the certification guide says that IDs may or may not be reset when DELETE without WHERE is used to empty a table, but what caused the ID sequence to be so weird? I am quite certain that's the order the rows were inserted. Originally before delete I had 6 rows in the table so 7, 8, 9 seems understandable .</p>