McBrearty
>
>ATG Automation Technologies Group Ltd.
> -Original Message-
> From: Paul DuBois [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, May 08, 2001 12:53 AM
> To: Kevin McBrearty; [EMAIL PROTECTED]
> Subject: Re: AUTO_INCREMENT Confusion>>
> At 12:14 AM -0
From: Paul DuBois [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, May 08, 2001 12:53 AM
> To: Kevin McBrearty; [EMAIL PROTECTED]
> Subject: Re: AUTO_INCREMENT Confusion
>
>
> At 12:14 AM -0400 5/8/01, Kevin McBrearty wrote:
> >I'm a bit confused about AUTO-INCREMENT b
From: Paul DuBois [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, May 08, 2001 12:53 AM
> To: Kevin McBrearty; [EMAIL PROTECTED]
> Subject: Re: AUTO_INCREMENT Confusion
>
>
> At 12:14 AM -0400 5/8/01, Kevin McBrearty wrote:
> >I'm a bit confused about AUTO-INCREMENT b
At 12:14 AM -0400 5/8/01, Kevin McBrearty wrote:
>I'm a bit confused about AUTO-INCREMENT behaviour. I have a table with an
>AUTO-INCREMENT column defined as int unsigned primary key. Records are
>regularly added and then later deleted from this table. If the last record
>is deleted, the sequence
I'm a bit confused about AUTO-INCREMENT behaviour. I have a table with an
AUTO-INCREMENT column defined as int unsigned primary key. Records are
regularly added and then later deleted from this table. If the last record
is deleted, the sequence begins at 1 again.
Reading from MySQL (Paul Dubois)