title: How to decrement the sequence on an column with auto increment as a constraint, when records are deleted
body: <pre><code>create table quiz(E_Id INT NOT NULL AUTO_INCREMENT PRIMAR KEY, E_name VARCHAR(255), E_Salary INT)
  </code></pre>
  
  <p>now whenever i insert data intop table, auto increment works as expected.
  Now when i delete the record the sequence of number doesnot get decrement.</p>
  
  <p>Suppose I have a records with Id 1, 2, 3, 4, 5. When i delete the 2 and 3 rd records, the sequence continues from the number 6. I want that if a records is deleted it numbering should get decrement  automatically</p>