title: Reset auto increments with data still in table MYSQL
body: <p>Most posts I have seen have been about resetting the auto-increments on empty tables.
  I have got a table with data in it that has had old record deleted from it. In the past my search has come up with answers like "leave it it doesnt matter" 
  I want to be a neat freak and clean up my tables. What is the best way to do this? should i move everything to a new table and truncate the old one then move it all back? would the auto-increment values move with it or would they start from 1 when i move the data around?</p>