| Re: deleted primary key can't be reused? [message #181829 is a reply to message #181827] |
Sat, 08 June 2013 15:46   |
Luuk
Messages: 329
Registered: September 2010
Karma:
|
Senior Member |
|
|
On 08-06-2013 16:24, richard wrote:
> Entered 100 items into 2 columns each.
> Deleted 2.
> Upon entering new record using id of 98, no can do.
> The next new record number becomes 101.
> "Duplicate key error" is issued.
> How do I take back the deleted key number so I can use it again?
> No, I do not mean the data that is in the record.
> To me, once a record is deleted, the key index should reflect that the
> record no longer exists, so the key index should be -1 of what it was.
> Not continue its esistance.
>
while this seems to be a mysql question,
It would be better to post the output of
show create table <tablename>
An index that is set to 'auto_increment' is always auto-incremented...
|
|
|
|
Calendar
Search
Help
Members
Register
Login
Home
]