Re: [PHP-DB] Auto Increment Problems.... From: Georgie Casey (webmaster <email protected>)
Date: 07/29/02

why, is this question asked a lot??? anywa, thanks, i was gonna try
something like that from something i read in the mysql manual, but it only
mentioned it passing and didnt give an example or anything.

tanx

"Daniel Brunner" <daniel.brunner <email protected>> wrote in message
news:CE4D94F0-A32C-11D6-A75E-00306589E6DA <email protected>
> Once again...
>
>
> ALTER TABLE table1 AUTO_INCREMENT = 500
>
>
> Dan
>
>
>
> On Monday, July 29, 2002, at 10:44 PM, webmaster <email protected> wrote:
>
> > rite,
> >
> > my primary key column ("id") is set to auto_increment as usual which is
> > very
> > handy. But when I delete a row, the auto_increment just keeps
> > incrementing
> > and there's this 'hole' left where I deleted the row!
> >
> > Apart from this looking ugly, it poses another problem. In my PHP script
> > where I can add new rows, I query the table, checking how many rows in
> > the
> > table altogether and set the new id as the next number, but this doesnt
> > work
> > if theres 'holes' in the id field, as the new record tries to overwrite
> > another id.
> >
> > So I've 2 questions
> > 1) Can the next auto_increment value be 'set' by a SQL query????
> > 2) Can I get a SQL query to INSERT INTO the first 'hole' it finds in
> > the ID
> > column??
> >
> > TIA
> >
> >
> >
> > --
> > PHP Database Mailing List (http://www.php.net/)
> > To unsubscribe, visit: http://www.php.net/unsub.php
> >
> 

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php