DUPLICATE ENTRY '127' FOR KEY 1

Last update on February 20, 2009 10:39 AM by deri58
Published by deri58

DUPLICATE ENTRY '127' FOR KEY 1


If you are using MySQL and you are facing the error “duplicate entry ‘127’ for key 1” while trying to make an entry in your database table, do not panic. This should be linked to the following and can easily be solved as indicated below:
  • When the primary key of a table is set to TINYINT,
  • The TINYINT capacity is less than 1 byte.
  • A TINYINT field can normally seize only 128 values

Solution


To solve this issue, you can choose two solutions:
  • 1. Either you try to use a different table command to increase the auto-increment value of the field,
  • 2. Choose the primary key from a TINYINT to an INT type.


See also :
http://dev.mysql.com/doc/refman/5.1/en/numeric-types.html

You can also post your probleme on our kioskea forum which you can accessed on below link:
http://en.kioskea.net/forum/forum 3 programming
Best answers for « DUPLICATE ENTRY '127' FOR KEY 1 » in :
Call Of Duty : United Offensive Expansion Show
Avira key Show
Download Password Generator Professional 2008 Show Your documents sometimes deserve more complex passwords than usual. But you do not know how to do that. Password Generator Professional is a powerful program to generate safe and complex passwords from random numbers (figures, letters). The...
Changing Windows Vista product key ShowChanging Windows Vista product key Like XP, it is possible to change the license key for your Vista. However, reactivation is required. To do this: Go to Start> right click Computer> Properties At the bottom of the page,...
[Keyboard]The Insert key ShowThe Insert key Insert mode Replacement Mode On most computer keyboards is a button called Insert (INS). This key is usually above the arrow keys, and beside the Delete key Its main use is the switching between two modes of entry of...
[Ubuntu 9.04] Installing VLC 1.0 Show[Ubuntu 9.04] Installing VLC 1.0 Here are the steps to install VLC 1.0 on Ubuntu sudo apt-key adv --recv-keys --keyserver keyserver.ubuntu.com 7613768D sudo bash -c 'echo "deb http://ppa.launchpad.net/c-korn/vlc/ubuntu jaunty main" >...
Download 1 Click XP Repair Pro Show
Download HP USB Disk Storage Format Tool ShowHP USB Disk Storage Format Tool is a small utility allowing to format a key USB or READER MP4. It also allows to make a key (Bootable). This software works with all keys and readers MP4 of the market. To make work this utility under Windows...
Download WIFI Key Generator ShowWifi Connections are certainly very practical, but given that they require no wiring, everybody can be connected to it if his computer is compatible with Wifi. WIFI Key Generator is a small application intended to generate random protection keys for...
Multichannel audio (5.1, 6.1, 7.1) ShowMultichannel audio The term "multichannel audio" refers to the use of multiple audio tracks to reconstruct sound on a multi-speaker sound system. Two digits separated by a decimal point (2.1, 5.1, 6.1, 7.1, etc.) are used to classify the various...
Private-key (or secret-key) cryptography ShowSymmetric encryption Symmetric encryption (also called private-key encryption or secret-key encryption) involves using the same key for encryption and decryption. Encryption involves applying an operation (an algorithm) to the data to be...
Public-key systems Showthe principle of public-key encryption The principle of asymmetric encryption (also called public-key encryption) first appeared in 1976, with the publication of a work about cryptography by Whitfield Diffie and Martin Hellman. In an asymmetric...
They need your help