> 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
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
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