title: mysql auto increment - use 1st available blank instead of the last number
body: <p>Instead of automatically adding the ID number after the last highest ID number, how can I:</p>
  <p>Automatically add the next available blank in sequence.</p>
  <p>ie</p>
  <p>I have a table with the following ID's that are taken</p>
  <p>1,2,5,9</p>
  <p>Instead of auto incrementing so the next one is 10, I'd like to know if possible I can automatically make the next ID 3.</p>
  <p>I have many ID's that need filling before I start adding more to the end.</p>