RE: AUTO_INCREMENT Confusion

2001-05-08 Thread Heikki Tuuri
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

RE: AUTO_INCREMENT Confusion

2001-05-08 Thread Kevin McBrearty
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

RE: AUTO_INCREMENT Confusion

2001-05-08 Thread Kevin McBrearty
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

Re: AUTO_INCREMENT Confusion

2001-05-07 Thread Paul DuBois
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

AUTO_INCREMENT Confusion

2001-05-07 Thread Kevin McBrearty
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)