HINTS: tinyint
----- Original Message -----
From: "Soheil Shaghaghi" <soheils@stripped>
To: <mysql@stripped>
Sent: Monday, April 08, 2002 9:59 AM
Subject: Help with Tables Please
> 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,
> FieldName tinytext NOT NULL,
> ShownRegistration tinyint(3) unsigned DEFAULT '0' NOT NULL,
> Required tinyint(4) DEFAULT '0' NOT NULL,
> DisplayName tinytext NOT NULL,
> DisplayNameFarsi tinytext NOT NULL,
> ModifyFlag tinyint(3) unsigned DEFAULT '1' NOT NULL,
> ShownProfile tinyint(3) unsigned DEFAULT '0' NOT NULL,
> ProfileRequired tinyint(4) DEFAULT '0' NOT NULL,
> ShownUpgradeAccount tinyint(3) unsigned DEFAULT '0' NOT NULL,
> UpgradeRequired tinyint(4) DEFAULT '0' NOT NULL,
> ShownMakeDonation tinyint(3) unsigned DEFAULT '0' NOT NULL,
> DonationRequired tinyint(4) DEFAULT '0' NOT NULL,
> FTPAllowed tinyint(3) unsigned,
> Price tinytext,
> PRIMARY KEY (FieldID)
> );
>
> Thanks
>
>
> ---------------------------------------------------------------------
> 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-thread105423@stripped>
> To unsubscribe, e-mail
<mysql-unsubscribe-sammy=team.outblaze.com@stripped>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
