How many positive integers do you expect a tinyint to hold?
Change it to an int or greater, and your problem should disappear.
You realize, though, that this is pure conjecture, since you did not
supply any information.
Mette Møller Madsen wrote:
> Hi there!
>
> When I try to insert more than 127 rows/records in a table I get this error:
>
> ERROR 1062: Duplicate entry '127' for key 1
> (the key is an auto incremented primary key)
>
> Does anyone know how to store _more_ than 127 rows in a table?
>
> My guess is that I need to change to settings of my db, but I cannot find
> anything in the manual. (I'm running version 3.23.38 which should be a
> stable one.)
>
> best regards,
> Mette Madsen
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
><[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
--
Gerald L. Clark
[EMAIL PROTECTED]
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
