title: How to update id set from 1?
body: <p>I have an <code>id</code> i.e primary key and auto increment. Is there any query to update my existing <code>id</code> and make my <code>id</code> start from 1 and next id 2 and so on..</p>
  
  <p>For example </p>
  
  <pre><code>id  name
  3   ABC
  5   XYZ
  9   PQR
  </code></pre>
  
  <p><strong>NOTE:</strong> <code>id</code> is already primary and auto increment and I don't want truncate my id.  </p>
  
  <p>if possible i want to get</p>
  
  <pre><code>id  name
  1   ABC
  2   XYZ
  3   PQR
  </code></pre>
  
  <p><code>ALTER TABLE table AUTO_INCREMENT = 1;</code> is not my solution.</p>
  
  <p>Thanks</p>