I verified his problem with 3.23.38 here using myisam files.
The key here is that the unique index is across TWO integer
fields, one of which is auto_increment.
Victoria Reznichenko wrote:
>Richard,
>Thursday, July 11, 2002, 7:26:00 PM, you wrote:
>
>RF> But the default table type is already MyI
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..
Wha
But the default table type is already MyISAM
> 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 no
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 a
>
> 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 actu
