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
incrementing
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
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
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 where I deleted
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