Error: Duplicate entry ‘0’ for key ‘PRIMARY’

For those arriving at this question because of the question title (as I did), this solved my problem:

This error can indicate that the table’s PRIMARY KEY is not set to AUTO-INCREMENT, (and your insert query did not specify an ID value).

To resolve:

Check that there is a PRIMARY KEY set on your table, and that the PRIMARY KEY is set to AUTO-INCREMENT.

How to add auto-increment to column in mysql database using phpmyadmin?

Related Posts:

  1. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  2. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  3. How do I restore a dump file from mysqldump?
  4. 1052: Column ‘id’ in field list is ambiguous
  5. 1052: Column ‘id’ in field list is ambiguous
  6. difference between primary key and unique key
  7. How to do a batch insert in MySQL
  8. Cannot delete or update a parent row: a foreign key constraint fails
  9. Case statement in MySQL
  10. Cannot delete or update a parent row: a foreign key constraint fails
  11. How do I import an SQL file using the command line in MySQL?
  12. #1273 – Unknown collation: ‘utf8mb4_unicode_520_ci’
  13. How do I quickly rename a MySQL database (change schema name)?
  14. What does SQL Select symbol || mean?
  15. What is the definition of cardinality in SQL
  16. Authentication plugin ‘caching_sha2_password’ cannot be loaded
  17. When to use SELECT … FOR UPDATE?
  18. SQL Query Where Field DOES NOT Contain $x
  19. Error Code: 2013. Lost connection to MySQL server during query
  20. How to join two tables by multiple columns in SQL?
  21. How to get size of mysql database?
  22. mysql Foreign key constraint is incorrectly formed error
  23. Selecting data from two different tables without using joins
  24. how to drop partition without dropping data in MySQL?
  25. MySQL: Invalid use of group function
  26. Creating a search form in PHP to search a database?
  27. Getting “Lock wait timeout exceeded; try restarting transaction” even though I’m not using a transaction
  28. Simple Random Samples from a Sql database
  29. ERROR 1452: Cannot add or update a child row: a foreign key constraint fails
  30. What does SQL clause “GROUP BY 1” mean?
  31. Generating a random & unique 8 character string using MySQL
  32. SQL select only rows with max value on a column
  33. Unknown Column In Where Clause
  34. SQL statement not working – “Operand type clash: date is incompatible with int’
  35. Convert partially non-numeric text into number in MySQL query
  36. Repair all tables in one go
  37. MySQL equivalent of DECODE function in Oracle
  38. How can I search (case-insensitive) in a column using LIKE wildcard?
  39. How to create a foreign key in phpmyadmin
  40. importing a CSV into phpmyadmin
  41. ERROR 1115 (42000): Unknown character set: ‘utf8mb4’
  42. Remove Primary Key in MySQL
  43. Is merge statement available in MySQL
  44. How do you properly prepare a %LIKE% SQL statement?
  45. What SQL Query to do a simple find and replace
  46. What’s a good strategy for planning WordPress DB growth?
  47. Scanning Database for malicious Data
  48. Getting wrong relationship value in $args in wp_Query?
  49. wpdb->prepare function remove single quote for %s in SQL statment
  50. How to Join two tables from separate databases within WordPress
  51. Would manually deleting the dumping data fix a “#1062 – Duplicate entry ‘1’ for key ‘PRIMARY'” phpMyAdmin error?
  52. How to execute mulitple statement SQL queries using $wpdb->query?
  53. Delete duplicate rows from wordpress database where a column is duplicate in phpmyadmin
  54. Query WordPress database by registered date and role
  55. wpdb_prepare with multiple or condition
  56. How do I find which articles are missing a featured image in The WordPress database?
  57. SQL Error wp_commentmeta – incorrect table definition
  58. How to find meta entries with their posts missing via SQL?
  59. How do I get the posts within a certain year/date(with sql query)?
  60. Database Tables Lost Indexes? How to Recover?
  61. SQL Database, repeated tables?
  62. Code to remove authors with no posts connected to them
  63. Which is better and faster ? WordPress Queries or SQL Query
  64. SQL Query in WordPress – Getting Impossible WHERE error
  65. Why this query is not showing any result on wordpresss home page?
  66. Using AND and bracket grouping in SQL not working
  67. How to get INSERT errors from $wpdb?
  68. SQL query to set posts in bulk based on the post content
  69. MySQL query for taxonomy-meta
  70. How can I write a formal sql query to get data from a custom table
  71. latency problems with wordpress install (from SQL import)
  72. Data is not constatntly loading from custom wordpress table
  73. DB prefix not updating
  74. Performing CRUD operations on front end in wordpress
  75. I wanted to Know that how can I give ingore to 0000-00-00 in my config file
  76. Find locations of all featured images of draft posts via SQL
  77. SQL query to change custom field in WordPress database
  78. Bulk find & replace on WordPress posts/pages (minus image paths)
  79. How to show result of sql query in a page?
  80. update_option returns false in AJAX, how to debug?
  81. How to create index (sql) to a meta_key?
  82. Improving performance of SQL sub-queries in WordPress
  83. The function is deprecated; use mysql_real_escape_string() instead
  84. Delete all users meta that named: user_avatar
  85. An SQL query to find orphaned image attachments and their meta
  86. The MySQL Connection could not be established., before it was joomla but i have change it into worpress
  87. WPDB delivers wrong results from complex queries
  88. How to change link in all posts?
  89. Display MySQL as part of a Page
  90. optimise SQL wordpress call
  91. Woocommerce: Grab total revenue of a product over all orders
  92. Migrated to Namecheap, now Trouble with Database & wp-config [closed]
  93. Delete posts with word count less than x number of words
  94. SQL query : Select a thumbnail for a media
  95. SQL command to export post_content from wp_posts using phpMyAdmin
  96. why you don’t Implement PDO for access every thing to database
  97. SQL Query to get post_id from wp_posts and and meta_key(s) from wp_postmeta
  98. SQL get last entry of a specific gravity form
  99. Is there an equivalent of MySQL’s SHOW CREATE TABLE in Postgres?
  100. Possible SQL injection. How to locate and fix?

Leave a Comment