title: Make auto increment fill previously deleted number
body: <blockquote>
    <p><strong>Possible Duplicate:</strong><br>
    <a href="https://stackoverflow.com/questions/12967588/using-unused-primary-keys">Using unused primary keys</a>  </p>
  </blockquote>
  
  
  
  <p>I created a table with an id column with auto increment
  Now when I deleted the rows with the id's 8,12,30 in that table. </p>
  
  <p>Now when I insert a new record I want to insert the next record into 8 then 12 etc.. </p>
  
  <p>Is there a way to get MySQL auto increment to do this for me?</p>
  
  <p>I tried to set autoincrement to some number, but I don't want to do it that way.</p>