Re: Help with Tables Please

[Dan Nelson]

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