title: auto increment primary key with delete in mysql
body: <p>I have a table with an ID AUTO INCREMENT PRIMARY KEY. When I delete an entry and re-add one, the new entry does not take the ID of the previous one instead it increments again by one.</p>
  
  <p>How to change this behaviour to get the id of deleted record to newely add record?</p>