On Mon, 29 Jul 2002 20:44:54 -0700
Georgie Casey "Georgie Casey" <[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 whe
Casey" To: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] Auto Increment
Problems
Yeah, it's asked a lot!!
And I've always answered that question( it's not the only question I
answer!!! )
But Good Luck!! And your welcome!!!
Dan
On Monday, July 29, 2002, at 10:51 PM, [EMAIL PROTECTED] wrote:
> why, is this question asked a lot??? anywa, thanks, i was gonna try
> som
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" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PRO
Once again...
ALTER TABLE table1 AUTO_INCREMENT = 500
Dan
On Monday, July 29, 2002, at 10:44 PM, [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
> increment
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
