mysql error! gah - this keeps annoying me! :(

PoorDoggie · 11-01-2006, 02:06 PM

This is the error I get when I try to input more records into a table.

Code:

Duplicate entry '127' for key 1

The "auto_increment" value is "127".

Why is this happening? How can I stop it? I have tried to change the auto_increment value, but it won't let me!

Thanks
Tom

beaver6813 · 11-02-2006, 01:04 AM

Erm thats slightly confusing, when inputting into a table i always set the primary key to INT type. Set the value to 255 (thats the max you can go up to) and then set it to auto_increment. Try changing the structure of the table using the way i said above. Tell me how it goes.

kzaid1 · 11-02-2006, 02:14 AM

A primary key can't be duplicated it has to be unqiue
that why people usually set it to auto_increment so sql
automatically sets the key. beaver6813 will work and
if you do want to set it like beaver6813 stated then you
would have to check if the key exists in the table before
inserting a new one

PoorDoggie · 11-02-2006, 02:18 AM

Originally Posted by kzaid1

A primary key can't be duplicated it has to be unqiue
that why people usually set it to auto_increment so sql
automatically sets the key. beaver6813 will work and
if you do want to set it like beaver6813 stated then you
????: NamePros.com http://www.namepros.com/programming/253267-mysql-error-gah-keeps-annoying-me.html
would have to check if the key exists in the table before
inserting a new one

nomally though, it all just works dosen't it?

I usually put the value "NULL" for the primary key field eg:

Code:

INSERT INTO table VALUES (NULL, 'PoorDoggie', 25);

dosen't that work?

Thanks
Tom

UPDATE: Ah... i had the primary key field as a "tiny_int" not an "int". This is probably why? It appears to be working now I have changed it.

Peter · 11-02-2006, 03:25 AM

Originally Posted by PoorDoggie

UPDATE: Ah... i had the primary key field as a "tiny_int" not an "int". This is probably why? It appears to be working now I have changed it.

Yes that was the cause of your problem. The highest value for a tiny_int is 127
????: NamePros.com http://www.namepros.com/showthread.php?t=253267

http://dev.mysql.com/doc/refman/4.1/...ric-types.html

beaver6813 · 11-02-2006, 09:29 AM

Rep gladly accepted

PoorDoggie · 11-03-2006, 02:24 AM

Originally Posted by beaver6813

Rep gladly accepted

lol.... not subtle

????: NamePros.com http://www.namepros.com/showthread.php?t=253267

I would be glad to give you some rep lol - I always forget.

11-01-2006, 02:06 PM	THREAD STARTER #1 (permalink)
PoorDoggie Soon to be RICHdoggie! Join Date: Jan 2005 Location: UK Posts: 2,408	mysql error! gah - this keeps annoying me! :( This is the error I get when I try to input more records into a table. Code: Duplicate entry '127' for key 1 The "auto_increment" value is "127". Why is this happening? How can I stop it? I have tried to change the auto_increment value, but it won't let me! Thanks Tom

11-02-2006, 01:04 AM	#2 (permalink)
beaver6813 NamePros Regular Join Date: May 2005 Location: England Posts: 392 Follow @beaver6813	Erm thats slightly confusing, when inputting into a table i always set the primary key to INT type. Set the value to 255 (thats the max you can go up to) and then set it to auto_increment. Try changing the structure of the table using the way i said above. Tell me how it goes. __________________ -Beaver6813.com - Web Developer Extraordinaire!

11-02-2006, 02:14 AM	#3 (permalink)
kzaid1 New Member Join Date: Jul 2006 Posts: 16	A primary key can't be duplicated it has to be unqiue that why people usually set it to auto_increment so sql automatically sets the key. beaver6813 will work and if you do want to set it like beaver6813 stated then you would have to check if the key exists in the table before inserting a new one __________________ Developer

11-02-2006, 09:29 AM	#6 (permalink)
beaver6813 NamePros Regular Join Date: May 2005 Location: England Posts: 392 Follow @beaver6813	Rep gladly accepted __________________ -Beaver6813.com - Web Developer Extraordinaire!

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)