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 thousand of lines added each day (and all lines older than a week are deleted)With AUTO_INCREMENT, one day or

Re: Automatic Primary Key for circular table

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