[ale] Auto increment in MySQL

George Carless kafka at antichri.st
Thu Sep 15 21:22:07 EDT 2005


On Thu, Sep 15, 2005 at 06:31:00PM -0500, ChangingLINKS.com wrote:
> On Wednesday September 14 2005 21:34, Christopher Fowler 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?
> 
> I think not.
> For that, skip auto_increment and code it.

Do what?

Honestly, if you're worried about "filling the holes" then your table 
scheme is poorly designed.  Rethink the index.

--George



More information about the Ale mailing list