Check your AUTO_INCREMENT column. You probably have it set to a TINYINT
(0-128). Use ALTER TABLE to change it to an INT or BIGINT.
I hope this helps.
Pat...
----- Original Message -----
From: "Mette Møller Madsen" <[EMAIL PROTECTED]>
To: "mysql listserver" <[EMAIL PROTECTED]>
Sent: Friday, June 15, 2001 7:46 AM
Subject: Can only create 127 records in a table :o(
> 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
>
---------------------------------------------------------------------
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
