---
title: "Discussion on \"SQL: Repair Auto Increment of a Table\" | Hashnode"
description: "Discussion on \"SQL: Repair Auto Increment of a Table\". Occasionally it happens that overlaps occur in a large table and the message Duplicate entry '0' for key 'PRIMARY' for query then gets the upper hand in the error logs. This error can be fixed quite easily with a short line of SQL.\nFix duplicate entr..."
url: "https://hashnode.com/posts/sql-repair-auto-increment-of-a-table/62a21a8ba4c962768fc3562b"
---

[Feed](https://hashnode.com/feed) /

Discussion

# [SQL: Repair Auto Increment of a Table](https://en.pixelbart.de/sql-repair-auto-increment-of-a-table?utm_source=hashnode&utm_medium=feed)

Occasionally it happens that overlaps occur in a large table and the message Duplicate entry '0' for key 'PRIMARY' for query then gets the upper hand in the error logs. This error can be fixed quite easily with a short line of SQL. Fix duplicate entr...

Jun 9, 2022 · 2 min read · en.pixelbart.de  
Read the article

-   [#sql](https://hashnode.com/tag/sql)
-   [#wordpress](https://hashnode.com/tag/wordpress)

## Written by

[Kevin Pliester](https://hashnode.com/@pixelbart)

@pixelbart · Germany

  
[View profile](https://hashnode.com/@pixelbart)

Webdev

Speaks many languages, but currently only uses PHP, JavaScript and WordPress (I consider it its own language, since it's a big sandbox).

## Responses 1

Markdown supported · ⌘↵ to post

[Kevin Pliester](https://hashnode.com/@pixelbart)

[Jun 9, 2022](https://hashnode.com/posts/sql-repair-auto-increment-of-a-table/62a21a8ba4c962768fc3562b/comment/62a21adc6cc4647a1b005081)

You know of any other fixes? Share them in the comments so everyone knows about them!

Stay healthy!
