List:General Discussion« Previous MessageNext Message »
From:Rui Monteiro Date:August 30 2004 2:58pm
Subject:Duplicate Keys when auto-increment??
View as plain text  
Hello there,

 

Does anyone ever had this problem:

 

Table Hello ***********

 

id - (PK) auto-increment

name - text

.

**************************

 

After some insert's, the table starts to getting erros due to "Duplicate
entry" for the ID.

But the ID is been auto-incremented!

 

I do something like this:

 

Insert into hello values ('','wedmwe')

 

Or 

 

Insert into hello (name) values ('werio')

 

 

Why is the error happening now? It started at the 127th entry.

 

Thanks for the help.

 

 



Thread
Duplicate Keys when auto-increment??Rui Monteiro30 Aug
  • Re: Duplicate Keys when auto-increment??Dan Nelson30 Aug
    • RE: Duplicate Keys when auto-increment??Rui Monteiro30 Aug
  • Re: Duplicate Keys when auto-increment??Michael Stassen30 Aug
AW: Duplicate Keys when auto-increment??KSTrainee30 Aug
RE: Duplicate Keys when auto-increment??John McCaskey30 Aug