title: How to reset the auto increment number/column in a MySql table
body: <p>The item_category_id column is auto increment value in the mysql table. </p>
  
  <p>I need to delete all the values &amp; next insertion should start from 1. If i delete all values &amp; try to insert a new row then it starts with some 30's &amp; 40's.</p>
  
  <pre><code>  item_category_id  item_category_name
      1                     qqq
      25                    ccc
      32                    vvv
      29                    bb
      4                     bbb
      31                    hhh
      34                    mmm
      33                    rrr
  </code></pre>