title: MySQL - ID issue
body: <p>The basic problem, I have a column called 'ID' which is set to AUTO_INCREMENT and PRIMARY index.</p>
  
  <p>If I add a row it sets the ID to 1, next row to 2, etc. It's working fine.</p>
  
  <p>But when I have for example 6 rows with IDs: <code>1, 2, 3, 4, 5, 6</code> and I delete row with, for example, ID = 6, so it's: <code>1, 2, 3, 4, 5</code> now, and I add a new row, it doesn't get ID = 6, instead ID = 7. So it's: <code>1, 2, 3, 4, 5, 7</code>. What's t he problem?</p>
  
  <p>Why do you downvote my question? I just wanted to know...</p>