[Solved] How to solve MySQL error code: 1062 duplicate entry?

Error Message:



Error Code: 1062. Duplicate entry ‘%s’ for key %d


Example:


Error Code: 1062. Duplicate entry ‘1’ for key ‘PRIMARY’

Possible Reason:


Case 1: Duplicate value.


The data you are trying to insert is already present in the column primary key. The primary key column is unique and it will not accept the duplicate entry.

Case 2: Unique data field.


You are trying to add a column to an existing table which contains data and set it as unique.

Case 3: Data type –upper limit.


The auto_increment field reached its maximum range.

MySQL NUMERICAL DATA TYPE - STORAGE & RANGE

Solution:


Case 1: Duplicate value.


Set the primary key column as AUTO_INCREMENT.

ALTER TABLE table_name ADD column_name INT NOT NULL AUTO_INCREMENT PRIMARY KEY;

Now, when you are trying to insert values, ignore the primary key column. Also you can insert NULL value to primary key column to generate sequence number. If no value specified MySQL will assign sequence number automatically.





Case 2: Unique data field.


Create the new column without the assigning it as unique field, then insert the data and now set it as unique field now. It will work now!!!

Case 3: Data type-upper limit.


When the data type reached its upper limit, for example, if you were assigned your primary key column as TINYINT, once the last record is with the id 127, when you insert a new record the id should be 128. But 128 is out of range for TINYINT so MySQL reduce it inside the valid range and tries to insert it with the id 127, therefore it produces the duplicate key error.

In order to solve this, you can alter the index field, setting it into signed / unsigned INT/ BIGINT depending on the requirement, so that the maximum range will increase. You can do that by using the following command:

ALTER TABLE table_name MODIFY column_name INT UNSIGNED NOT NULL AUTO_INCREMENT;

You can use the following function to retrieve the most recently automatically generated AUTO_INCREMENT value:

mysql> SELECT LAST_INSERT_ID();

Final workaround:




After applying all the above mentioned solutions and still if you are facing this error code: 1062 Duplicate entry error, you can try the following workaround.

Step 1: Backup database:

You can backup your database by using following command:
mysqldump database_name > database_name.sql

Step 2: Drop and recreate database: 

Drop the database using the following command:
DROP DATABASE database_name;
Create the database using the following command:
CREATE DATABASE database_name;

Step 3: Import database:

You can import your database by using following command:
mysql database_name < database_name.sql;
After applying this workaround, the duplicate entry error will be solved. I hope this post will help you to understand and solve the MySQL Error code: 1062. Duplicate entry error. If you still facing this issue, you can contact me through the contact me page. I can help you to solve this issue.





41 comments:

  1. The article has genuinely peaks my interest. I’m planning to marker your website and maintain checking for brand new details. I actually idolized reading your journal, valuable data.

    ReplyDelete
  2. we have sell some merchandise of rotate custom boxes.it's far absolutely useful and completely low fee allure visits this web page thanks and appeal component this say thinking of your links. Facial Treatment

    ReplyDelete
  3. I never comment on blogs but your article is so best that I never stop myself to say something about it. You’re amazing Man, I like it Database Errors... Keep it up

    ReplyDelete
  4. Awesome and interesting article. Great things you've always shared with us. Thanks. Just continue composing this kind of post. entreprise informatique

    ReplyDelete
  5. That is the place IT specialists come in and it is actually why it tends to be so natural to discover lucrative chances in the event that you have the best possible measure of innovation based information.
    information technology

    ReplyDelete
  6. Great job for publishing such a beneficial web site. Your web log isn’t only useful but it is additionally really creative too. skytechosting.com

    ReplyDelete
  7. Thanks for your insight for your fantastic posting. I’m glad I have taken the time to see this. ternopil national medical university

    ReplyDelete
  8. I recommend that you ask for a free trial session. cursos de ti

    ReplyDelete
  9. This is awesome post. I really like it. I will also want to know APK Game Killer is good or not?

    ReplyDelete
  10. We are really grateful for your blog post. You will find a lot of approaches after visiting your post. I was exactly searching for. Thanks for such post and please keep it up. Great work water softeners

    ReplyDelete
  11. Your writers are your resources in providing quality articles to your clients. Obviously, a badly written article reflects the type of service that you offer. Helphub

    ReplyDelete
  12. I have read a few of the articles on your website now, and I really like your style of blogging. I added it to my favorites blog site list and will be checking back soon. Please check out my site as well and let me know what you think. fue hair transplant in lucknow

    ReplyDelete
  13. I was reading your article and wondered if you had considered creating an ebook on this subject. Your writing would sell it fast. You have a lot of writing talent. techno tech blog

    ReplyDelete
  14. Now, the question would be how someone will analyze data in the aforementioned manner and give some useful results. 360DigiTMG data science training in hyderabad

    ReplyDelete
  15. This Was An Amazing ! I Haven't Seen This Type of Blog Ever ! Thank you For Sharing
    https://socialprachar.com/data-science/

    ReplyDelete
  16. It is a great website.. The Design looks very good.. Keep working like that!. Seo house.

    ReplyDelete
  17. For full coverage, use a can of spray adhesive or a Xyron machine. To use your Xyron machine, just roll the die cut or item you want to completely cover through the machine with the piece face down (just opposite of how you normally do it), then apply the glitter. Craft glitter bulk

    ReplyDelete
  18. I was looking at some of your posts on this website and I conceive this web site is really instructive! Keep putting up.. erek erek 2d

    ReplyDelete
  19. Although this is not a magic tool which will write on your behalf but it can enhance and improve your writing style to a professional level. Essay Writing Service

    ReplyDelete
  20. Data Science helps in combining the disruption into categories and communicating their potential, which allows data and analytics leaders to drive better results.
    Data Science Course in Hyderabad

    ReplyDelete
  21. You completed certain reliable points there. I did a research on the subject and found nearly all persons will agree with your blog.
    data scientist courses

    ReplyDelete
  22. I am a new user of this site so here i saw multiple articles and posts posted by this site,I curious more interest in some of them hope you will give more information on this topics in your next articles.
    ddata science course in Hyderabad

    ReplyDelete
  23. Can you make tiktok video how you do it? On this site https://soclikes.com/buy-tiktok-likes you can buy tiktok likes for this video

    ReplyDelete
  24. Where telethons of the 1980s such as Live Aid attempted to create a buzz and sense of public involvement through telephone technology, this can be done faster today using the internet.  Audiences can watch events in real time and engage in online 'chat' behaviors as events unfold. data science course syllabus

    ReplyDelete
  25. If you want to start a blog about code you can buy instagram followers from this site https://viplikes.in

    ReplyDelete
  26. Really nice and interesting post. I was looking for this kind of information and enjoyed reading this one. Keep posting. Thanks for sharing.
    data science course in India

    ReplyDelete
  27. This post is great. I really admire your post. Your post was awesome. data science course in Hyderabad

    ReplyDelete
  28. I favor the entire group of products, Considered truly loved, I want more information. about this, thinking about that it's fairly good., Many thanks a great deal with regards to displaying. Big pharma Companies

    ReplyDelete
  29. Python is also quite useful as a modern scripting language similar to Perl, which can used to tie disparate systems together. data science course in india

    ReplyDelete
  30. This post is very simple to read and appreciate without leaving any details out. Great work!
    data scientist course noida

    ReplyDelete
  31. You totally coordinate our desire and the assortment of our data.
    data scientist malaysia

    ReplyDelete
  32. Exceptional data you gave us. This coronavirus is getting to be perilous day by day. We all need to work together in this awful circumstance. We all got to keep up social remove so that this infection may not be skewered quick. Perching stool

    ReplyDelete
  33. I am not a Mysql coding specialist or developer. Rather I am an apprentice with poor coding knowledge. But after entering in this post, I was so pleased getting something to pink up in my knowledge. The erro coding details and probable solution you explained in this post was so praiseworthy. Love this kind of great piece of quality job.
    IT solutions Richmond Hill

    ReplyDelete