title: Auto Increment Problem in Mysql
body: <p>I created a table and set a field to auto increment some thing like this:</p>
  
  <pre><code>CREATE TABLE t1(id BIGINT NOT NULL PRIMARY KEY AUTO_INCREMENT) ENGINE = MyISAM AUTO_INCREMENT = 123456; 
  </code></pre>
  
  <p>But to some reason i deleted some of the rows in the table.</p>
  
  <p>Now the question is when i insert new rows in the table the new rows should be assigned id's of the rows which have been deleted rather than assigning new id's.</p>
  
  <p>I do not want to reset all the id's</p>
  
  <p>How can i do this??</p>
  
  <p>Help appreciated:)</p>