Filed Under: SQL

Duplicate entry ‘127′ for key 1

19 October 2008 No Comment

Well I’m not so familar with SQL, that’s why I was struggling with that problems for about 10 minutes. Actually it’s fairly simply, the error message says that there is already an entry with the ID 127 in the database.
The problem is the size of the SQL field. A signed TinyINT can only save entries from -127 to 127, an unsigned TinyINT can hold entries that range from 0 to +255.

You can find some more information about it here.







Like our posts? Then subscribe via Mail:

Email:  

Similar Posts:

Socialize:

delicious stumbleupon

Leave your response!

Be nice. Keep it clean. Stay on topic. No spam.

You can use these tags:
<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong> <pre lang="" line="">

This is a Gravatar-enabled weblog. To get your own globally-recognized-avatar, please register at Gravatar.com.