title: auto increment after delete from a table
body: <blockquote>
    <p><strong>Possible Duplicate:</strong><br>
    <a href="https://stackoverflow.com/questions/740358/mysql-reorder-reset-auto-increment-primary-key">MySQL: Reorder/Reset auto increment primary key?</a>  </p>
  </blockquote>
  
  
  
  <p>if I delete from my table a ligne and in this table i have an auto increment ID , 
  DELETE From table where id=2</p>
  
  <p>after this the table will be like this </p>
  
  <pre><code> ID   | NAme
  1        aaa
  3        cccc
  </code></pre>
  
  <p>how can i fix the ID to be like this </p>
  
  <pre><code>ID   | NAme
  1        aaa
  2        cccc
  3        dddd  
  </code></pre>