title: Insert after truncate start from 1; but insert after delete resumes from previous value
body: <p>In my table there is column name id which is auto increment integer. When I truncate table and then try to perform insert query it starts from 1, but if I do delete operation and then try to insert then it just resumes from previous value. Why does insert query performs differently for delete and truncate. It should always start from 1 if there is not entry in table.</p>
  
  <p>Example : 
  (1) Original Table
  <a href="https://i.stack.imgur.com/lPtf8.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/lPtf8.png" alt="enter image description here"></a></p>
  
  <p>(2) delete all rows and then insert 
  <a href="https://i.stack.imgur.com/mDvTJ.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/mDvTJ.png" alt="enter image description here"></a></p>
  
  <p>(3) truncate the table then insert
  <a href="https://i.stack.imgur.com/FUZag.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/FUZag.png" alt="enter image description here"></a></p>