Are you saying that you want a table with a maximum of 127 records ? Or,
that due to your TINYINT, you are RESTRICTED to 127 records?
If you are restricted to records, change TINYINT to INT.
If you want to have ONLY 128 records, change TINYINT to TINYINT UNSIGNED,
which will permit records 1 through 255.
FYI: show us your table structure next time; please don't force us to guess
your structure
----- Original Message -----
From: Henning Olsen <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, April 19, 2002 7:38 AM
Subject: Max 127 records
Hey - can anyone help?
I have a MySql-db in which I can only have 127 records.
Using phpmyadmin to insert record number 128 (autoincrement) gets this
message:
INSERT INTO `kontakt` (`id`, `navn`, `adresse`, `postnummer`, `by`,
`telefon`, `kommentar`) VALUES ('', 'fsd', 'sfdg', 'sg', 'fdsg', 'sfg',
'sg');
MySQL returnerede:
Duplicate entry '127' for key 1
No matter what table or desing of table - the result is the same. Using
other interfaces than phpmyadmin gives the same result too.
Thanks for helping
Henning
---------------------------------------------------------------------
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
