Re: Using AUTO_INCREMENT like SEQUENCE - Resolved

2002-11-07 Thread Joseph Bueno
> > Mike Hillyer > > -Original Message- > From: Chuck Tomasi [mailto:Chuck.Tomasi@;plexus.com] > Sent: Monday, October 21, 2002 7:19 AM > To: [EMAIL PROTECTED] > Subject: RE: Using AUTO_INCREMENT like SEQUENCE - Resolved > > > This past weekend the solution came t

Re: Using AUTO_INCREMENT like SEQUENCE - Resolved

2002-10-21 Thread Paul DuBois
At 16:57 +0200 10/21/02, Joseph Bueno wrote: Hi all, Sorry to jump in the middle of this thread but there is a much simpler way to generate sequence numbers: You create an auxiliary table with a one row: CREATE TABLE sequence ( code int(11) DEFAULT '0' NOT NULL ); INSERT INTO sequence VALUES (