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 / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ 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 <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php