In the last episode (Apr 07), Soheil Shaghaghi said:
> Hi all, I have create the following mysql table, and when I try to
> add more than 128 rows in the table, I get this error: "Duplicate
> entry '127' for key 1" I have no duplicate entries in there, and I
> can not figure out what's going on!
>
> CREATE TABLE CMSHOWNREQUIREDFIELDS1 (
> FieldID tinyint(4) DEFAULT '0' NOT NULL,
> PRIMARY KEY (FieldID)
> );
This is a FAQ. TINYINT has a range of -127 to 127. Change it to INT.
--
Dan Nelson
[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
