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
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net
<___/ www.mysql.com
---------------------------------------------------------------------
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 <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
