List:General Discussion« Previous MessageNext Message »
From:Rick Emery Date:April 8 2002 6:08pm
Subject:RE: Help with Tables Please
View as plain text  
 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
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