Re: MySQL Error???

on 6/27/01 9:24 AM, Brian Grayless at bgrayless@Premier-Resorts.com wrote: > "1062: Duplicate entry '127' for key 1" > I wrote a great bookmark management program that works fine, but everytime I > insert bookmarks, I insert somewhere over 120 and I start getting this > error, and it won't add them anymore. Any suggestions??? It looks like you set your key column as a TINYINT type rather than say, an INT. Try ALTER'ing that column type to INT and see if it works. Sincerely, Paul Burney ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Paul Burney Webmaster && Open Source Developer UCLA -> GSE&IS -> ETU (310) 825-8365 <webmaster@gseis.ucla.edu> <http://www.gseis.ucla.edu/> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++