From: Dan Nelson
Date: April 8 2002 2:08am
Subject: Re: Help with Tables Please
List-Archive: http://lists.mysql.com/mysql/105424
Message-Id: <20020408020810.GH63541@dan.emsphone.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii

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