[ale] Auto increment in MySQL

[groups at changinglinks.com (ChangingLINKS.com)]

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.
-- 
Wishing you Happiness, Joy, and Laughter,
Drew Brown
http://www.ChangingLINKS.com