Thanks, It worked :)
It was my mistake!
Thanks again,
Soheil
Soheil,
Monday, April 08, 2002, 7:09:44 AM, you wrote:
SS> Thanks for the tip Dan,
SS> I changed it, but it still gives me the same error.
SS> Any other suggestion?
hm ... I have tested your example and it worked fine ...
What version of MySQL server do you use and how did you changed column
type?
SS> 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)
>> );
SS> This is a FAQ. TINYINT has a range of -127 to 127. Change it to INT.
--
For technical support contracts, goto https://order.mysql.com/
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Victoria Reznichenko
/ /|_/ / // /\ \/ /_/ / /__ Victoria.Reznichenko@stripped
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net
<___/ www.mysql.com
---------------------------------------------------------------------
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-thread105480@stripped>
To unsubscribe, e-mail
<mysql-unsubscribe-soheils=jhanna.com@stripped>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.