List:General Discussion« Previous MessageNext Message »
From:Gerald Clark Date:July 10 2002 4:01pm
Subject:Re: auto-increment usage question
View as plain text  
That is the normal behavior for ISAM type files.
Convert them to MYISAM.

Richard Fox wrote:

>>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
>
>
>---------------------------------------------------------------------
>Before posting, please check:
>   http://www.mysql.com/manual.php   (the manual)
>   http://lists.mysql.com/           (the list archive)
>
>To request this thread, e-mail <mysql-thread114200@stripped>
>To unsubscribe, e-mail
> <mysql-unsubscribe-gerald_clark=suppliersystems.com@stripped>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>


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