MySQL Lists are EOL. Please join:

List:General Discussion« Previous MessageNext Message »
From:Victoria Reznichenko Date:July 12 2002 10:55am
Subject:Re: Re: auto-increment usage question
View as plain text  
Richard,
Thursday, July 11, 2002, 7:26:00 PM, you wrote:

RF> But the default table type is already MyISAM

If you didn't set up another default table type.

Please, show us the output of
    SHOW TABLE STATUS LIKE "your_table_name";

Can you create a repeatable testcase?

And some more info..
What version of MySQL do you use? and what OS do you use?

>> 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
RF> forms
>> >>
>> >the
>> >
>> >>primary key for the table. run_id is not null and auto-increment. I
RF> 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
RF> a
>> >>value which is one higher than the greatest value remaining in the
RF> 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
RF> be
>> >>based on the current highest value in the table, but on the last
RF> assigned
>> >>run_id even if that record has been deleted?
>> >>
>> >>If not, are there any common workarounds?




-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___     ___ ____  __
  /  |/  /_ __/ __/ __ \/ /    Victoria Reznichenko
 / /|_/ / // /\ \/ /_/ / /__   Victoria.Reznichenko@stripped
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
       <___/   www.mysql.com



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