title: How update the whole values of an Auto-increment column in MySQl table
body: <p>I copy a table from another table in MySQL by considering some condition for inserting in new table. One the column of these tables is  defined as a <em>Auto-Increment</em> column which is caused a problem for me.The following table is my new table however, the new table id is not start from 1 to 5.</p>
  
  <pre><code>       +---------+---------+-----------+
      -&gt; | id      | type    | superType |
      -&gt; +---------+---------+-----------+
      -&gt; | 1210435 | /m/019_ | /m/0kpyln |
      -&gt; |  776693 | /m/01m9 | /m/014s   |
      -&gt; |  682533 | /m/01mh | /m/014s   |
      -&gt; |  764776 | /m/01mp | /m/014s   |
      -&gt; |  685170 | /m/01n7 | /m/014s   |
      -&gt; +---------+---------+-----------+
  </code></pre>
  
  <p>How can I solve this problem?</p>