MySQL Lists are EOL. Please join:

List:General Discussion« Previous MessageNext Message »
From:Richard Fox Date:July 10 2002 2:07pm
Subject:Re: auto-increment usage question
View as plain text  
>
> Hi,
>
> I have a mysql table which has a run_id which together with user_id forms
the
> primary key for the table. run_id is not null and auto-increment. I delete
> records from this table, and add new records. I want the run_id to keep
> incrementing and not reuse values, but here is the actual behavior:
>
>     When records are deleted, upon the next insert run_id will be given a
> value which is one higher than the greatest value remaining in the table.
If
> the table is empty, run_id will be assigned '1'.
>
> Is there any way in which I can get run_id to keep incrementing and not be
> based on the current highest value in the table, but on the last assigned
> run_id even if that record has been deleted?
>
> If not, are there any common workarounds?
>
> TIA
>
> Rich

sql, query

Thread
Re: auto-increment usage questionRichard Fox10 Jul
Re: auto-increment usage questionGerald Clark10 Jul
Re: auto-increment usage questionRichard Fox11 Jul
  • Re: Re: auto-increment usage questionVictoria Reznichenko12 Jul
Re: auto-increment usage questionGerald Clark12 Jul