[ale] Auto increment in MySQL

Grant Robertson me at grantrobertson.com
Wed Sep 14 22:55:28 EDT 2005


No, it will use the highest auto value in use at the time of alter in
that table, plus one. It would be a pretty bad idea for it to do much
else.

-G

On 9/14/05, Christopher Fowler <cfowler at outpostsentinel.com> wrote:
> 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?



More information about the Ale mailing list