ALTER TABLE causes auto_increment resequencing, resulting in duplicate entry ‘1’ for key ‘PRIMARY’

Posted by on January 7, 2012 Leave a comment (4) Go to comments

I got this error while trying to add auto_increment attribute to a MySQL table field:

ALTER TABLE causes auto_increment resequencing, resulting in duplicate entry ‘1’ for key ‘PRIMARY’

After some googling I found the solution: simply remove the record with ‘0’ for the primary key field. It seems that MySQL tries to adjust ‘0’ to ‘1’ for auto_increment field.

Database
  1. Dmitriy April 4, 2014 at 10:07 am

    Big thanks for this post! I got the same problem and fis it!

    Reply
  2. liguodon October 14, 2015 at 5:59 am

    😛
    yes, the same problem, delete the data with a ‘0’ id, problem solved.

    thx

    Reply
  3. shin February 22, 2016 at 10:18 am

    problem solved, thanks

    Reply
  4. Efent January 9, 2022 at 5:58 am

    thank you so much

    Reply

Leave a Comment


NOTE - You can use these HTML tags and attributes:
<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

This site uses Akismet to reduce spam. Learn how your comment data is processed.