FieldID INT UNSIGNED DEFAULT '0' NOT NULL,
-----Original Message-----
From: Soheil Shaghaghi [mailto:soheils@stripped]
Sent: Sunday, April 07, 2002 11:10 PM
To: mysql@stripped
Subject: RE: Help with Tables Please
Thanks for the tip Dan,
I changed it, but it still gives me the same error.
Any other suggestion?
-----Original Message-----
From: Dan Nelson [mailto:dnelson@stripped]
Sent: Sunday, April 07, 2002 7:08 PM
To: Soheil Shaghaghi
Cc: mysql@stripped
Subject: Re: Help with Tables Please
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
dnelson@stripped
---------------------------------------------------------------------
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 <mysql-thread105424@stripped>
To unsubscribe, e-mail
<mysql-unsubscribe-soheils=jhanna.com@stripped>
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 <mysql-thread105429@stripped>
To unsubscribe, e-mail <mysql-unsubscribe-remery=excel.com@stripped>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
