MySQL Lists: mysql: RE: Duplicate Keys when auto-increment??

List:	General Discussion	« Previous Message Next Message »
From:	Rui Monteiro	Date:	August 30 2004 3:07pm
Subject:	RE: Duplicate Keys when auto-increment??
View as plain text

Wow! That simple! :D

Many thanks! :D

-----Mensagem original-----
De: Dan Nelson [mailto:dnelson@stripped] 
Enviada: segunda-feira, 30 de Agosto de 2004 16:04
Para: Rui Monteiro
Cc: mysql@stripped
Assunto: Re: Duplicate Keys when auto-increment??

In the last episode (Aug 30), Rui Monteiro said:
> After some insert's, the table starts to getting erros due to "Duplicate
> entry" for the ID.
> 
> Why is the error happening now? It started at the 127th entry.

Never use tinyints as your autoincrement column.

-- 
	Dan Nelson
	dnelson@stripped

Thread
• Duplicate Keys when auto-increment??	Rui Monteiro	30 Aug
• Re: Duplicate Keys when auto-increment??	Dan Nelson	30 Aug
• RE: Duplicate Keys when auto-increment??	Rui Monteiro	30 Aug
• Re: Duplicate Keys when auto-increment??	Michael Stassen	30 Aug
• AW: Duplicate Keys when auto-increment??	KSTrainee	30 Aug
• RE: Duplicate Keys when auto-increment??	John McCaskey	30 Aug