Your autoincrement column is of type TINYINT. This type is specifically
designed to only hold numbers from 0 to 127. For best results, use an
INTEGER - they can accept numbers up to 99999999999 IIRC.
HTH
Jon
-----Original Message-----
From: Mette Møller Madsen [mailto:[EMAIL PROTECTED]]
Sent: 15 June 2001 12:46
To: mysql listserver
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
**********************************************************************
'The information included in this Email is of a confidential nature and is
intended only for the addressee. If you are not the intended addressee,
any disclosure, copying or distribution by you is prohibited and may be
unlawful. Disclosure to any party other than the addressee, whether
inadvertent or otherwise is not intended to waive privilege or
confidentiality'
**********************************************************************
---------------------------------------------------------------------
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
