MySQL Forums
Forum List  »  MyISAM

Advanced Search
New Topic

Re: Delete then insert causes duplicate key
Posted by: Bill Ferrett
Date: November 16, 2005 07:09AM

KimSeong Loh wrote:
> Try do a SELECT max(id) from orgsector
>
> Maybe the range of mediumint has been exhausted.


the 'duplicate' id is 23291 which is even within the range of a smallint.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
Delete then insert causes duplicate key
4867
Bill Ferrett
November 15, 2005 06:55AM
Re: Delete then insert causes duplicate key
2027
KimSeong Loh
November 15, 2005 08:53PM
Re: Delete then insert causes duplicate key
1904
Bill Ferrett
November 16, 2005 07:09AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.