title: Fill in gaps in ID column in MySQL
body: <blockquote>
    <p><strong>Possible Duplicate:</strong><br>
    <a href="https://stackoverflow.com/questions/1841104/how-to-fill-in-the-holes-in-auto-incremenet-fields">How to fill in the “holes” in auto-incremenet fields?</a>  </p>
  </blockquote>
  
  
  
  <p>I have a problem when deleting a user in my database, the ID column always skips and just continues to increment, even if there are skipped numbers inside the column.</p>
  
  <p>For ex:</p>
  
  <pre><code>+---------+----------+---------+
  |   ID    |  first   |   last  |
  +---------+----------+---------+
  |    1    |    a     |    a    |
  +---------+----------+---------+
  |    3    |    c     |    c    |
  +---------+----------+---------+
  |    4    |    d     |    d    |
  +---------+----------+---------+
  |    5    |    e     |    e    |
  +---------+----------+---------+
  |    7    |    g     |    g    |
  +---------+----------+---------+
  |    9    |    i     |    i    |
  +---------+----------+---------+
  </code></pre>
  
  <p>Is there anyway to automatically fill in the gap on my ID column when creating a new user?
  Or just adjust the remaining users on the list to fill in the gap?</p>