Re: Automatic Primary Key for "circular table"

2002-05-29 Thread Alec . Cawley
> I'm looking for a way to create a table with a ID columns (PRIMARY KEY) > generated automatically... > The only probleme is that i cannot use a AUTO_INCREMENT field because I have > thousand of lines added each day (and all lines older than a week are > deleted)With AUTO_INCREMENT, one

Re: Automatic Primary Key for "circular table"

2002-05-29 Thread Hisseine Dj.
May 29, 2002 10:45 AM Subject: Automatic Primary Key for "circular table" > Hi,, > > I'm looking for a way to create a table with a ID columns (PRIMARY KEY) > generated automatically... > > The only probleme is that i cannot use a AUTO_INCREMENT field because I have

Automatic Primary Key for "circular table"

2002-05-29 Thread Jonathan Pelletier
Hi,, I'm looking for a way to create a table with a ID columns (PRIMARY KEY) generated automatically... The only probleme is that i cannot use a AUTO_INCREMENT field because I have thousand of lines added each day (and all lines older than a week are deleted)With AUTO_INCREMENT, one day or a