[ale] Auto increment in MySQL

Christopher Fowler cfowler at outpostsentinel.com
Wed Sep 14 22:34:48 EDT 2005


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