SQL Error

[dpdesign]

hi, I'm new in this Forum (what a wonder;-)) )

and as well as all new members here I got a question:

-I've a data bank, and when I add an entry over 127, there is an error like this:

"" Duplicate entry '127-127' for key 1 ""

can someone help me?

greetings dpdesign ;-)

 

[r937]

don't use tinyint for an auto_increment column if you want your table to hold more than 127 rows


rudy

 

[dpdesign]

thx;-) rudy

greetings dpdesign

 

[sleipnir214]

Regardless of the bit-width of the column you use for the auto_increment values, I recommend in all cases that you use unsigned integers.

Want the best answers? Ask the best questions:

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

TANSTAAFL!