title: How to ensure no gaps in auto_increment numbers?
body: <p>i have a problem case with auto_incrementing, this is my table i have first it was so smooth to incrementing id* </p>
  
  <pre><code>id*      name
  1        name1
  2        name2
  3        name3
  4        name4
  5        name5
  6        name6
  </code></pre>
  
  <p>but when I delete a record and insert a new record the id starts from 7.</p>
  
  <pre><code>id*      name
  1        name1
  2        name2
  3        name3
  5        name5
  6        name6
  7        name7
  </code></pre>
  
  <p>this is what i want to make:</p>
  
  <pre><code>id*      name
  1        name1
  2        name2
  3        name3
  4        name7
  5        name5
  6        name6
  </code></pre>
  
  <p>I would like a solution where every number is filled in, so if I delete a row the next autoinc number will be the number that I deleted not the next number higher.</p>