SQL auto_increment

[mrtopher]

I am having a problem with a mysql database. It appears that a table in my database has stopped accepting records. I have a column that I am using as my primary key and it is auto_incremented everytime a new record is entered. That number has gotten up to 127 and now it wont allow any new records into the table.

This is the error I am getting:
"Duplicate entry '127' for key 1"

It sounds to me like my auto_increment has stopped incrementing at 127 and wants to repeat itself. Does anyone know what I can do about this?? Any help is greatly appreciated!

 

[sleipnir214]

What is the column type of the auto_increment column? It sounds like you used tinyint, which is only 8 bits. Unless you use tinyint unsigned, 127 will be the maximum value you can store.

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!

 

[mrtopher]

THATS IT!!

I have been trying to fix this problem for a while, and no one could give me an answer.

Thanks a lot!!

 

[sleipnir214]

As a general rule, I use at least "int unsigned" for auto_increment columns. That'll give you to 4294967295 before you run out of numbers.

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!