Hi,
> 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.)
perhaps you have the auto_increment-field set as a "smallint" which can
only store values up to 127? Use mediumint or int instead ...
Bye,
Thomas Karcher
---------------------------------------------------------------------
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
