title: reset auto increment id after deletion of last row
body: <p>I made a table in a mysql database for testing purposes. 
  The id is auto incremented. After doing this(not together)</p>
  
  <pre><code>delete from test where id=4;
  alter table test auto_increment = 4;
  insert into test(nume) values('dan');
  </code></pre>
  
  <p>It does not give any errors. But the last id is 5, not 4. Should not this be working?</p>