On Wed, 2005-09-14 at 21:34 -0400, George Carless wrote: > ALTER TABLE theTableInQuestion AUTO_INCREMENT=1234 > Here is a question. Lets say that I have a bunch of holes because I deleted various rows. can I set the value to 1 and MySQL will be smart enough to fill those holes?