List:General Discussion« Previous MessageNext Message »
From:Dan Nelson Date:April 8 2002 2:08am
Subject:Re: Help with Tables Please
View as plain text  
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
Thread
Follow up question to table typesCarl Schmidt8 Apr
  • Help with Tables PleaseSoheil Shaghaghi8 Apr
    • Re: Help with Tables PleaseDan Nelson8 Apr
      • RE: Help with Tables PleaseSoheil Shaghaghi8 Apr
        • Re: RE: Help with Tables PleaseVictoria Reznichenko8 Apr
          • RE: RE: Help with Tables PleaseSoheil Shaghaghi8 Apr
    • Re: Help with Tables PleaseSammy Lau8 Apr
RE: Help with Tables PleaseRick Emery8 Apr