MySQL 1062 – Duplicate entry ‘0’ for key ‘PRIMARY’

by

You need to specify the primary key as auto-increment 

CREATE TABLE `momento_distribution`
  (
     `momento_id`       INT(11) NOT NULL AUTO_INCREMENT,
     `momento_idmember` INT(11) NOT NULL,
     `created_at`       DATETIME DEFAULT NULL,
     `updated_at`       DATETIME DEFAULT NULL,
     `unread`           TINYINT(1) DEFAULT '1',
     `accepted`         VARCHAR(10) NOT NULL DEFAULT 'pending',
     `ext_member`       VARCHAR(255) DEFAULT NULL,
     PRIMARY KEY (`momento_id`, `momento_idmember`),
     KEY `momento_distribution_FI_2` (`momento_idmember`),
     KEY `accepted` (`accepted`, `ext_member`)
  )
ENGINE=InnoDB
DEFAULT CHARSET=latin1$$

With regards to comment below, how about:

ALTER TABLE `momento_distribution`
  CHANGE COLUMN `id` `id` INT(11) NOT NULL AUTO_INCREMENT,
  DROP PRIMARY KEY,
  ADD PRIMARY KEY (`id`);

A PRIMARY KEY is a unique index, so if it contains duplicates, you cannot assign the column to be unique index, so you may need to create a new column altogether

More Related Contents:

  1. Recreating a query using INNER JOIN? [duplicate]
  2. Create a Cumulative Sum Column in MySQL
  3. Equivalent of explode() to work with strings in MySQL
  4. How can I tell when a MySQL table was last updated?
  5. mysql select dynamic row values as column names, another column as value
  6. MySQL DELETE FROM with subquery as condition
  7. SQL – IF EXISTS UPDATE ELSE INSERT INTO
  8. SELECT / GROUP BY – segments of time (10 seconds, 30 seconds, etc)
  9. Is it possible to query a tree structure table in MySQL in a single query, to any depth?
  10. Simple Random Samples from a Sql database
  11. MySQL: Error Code: 1118 Row size too large (> 8126). Changing some columns to TEXT or BLOB
  12. What’s the difference between comma separated joins and join on syntax in MySQL? [duplicate]
  13. How do I use properly CASE..WHEN in MySQL
  14. Determine Rank based on Multiple Columns in MySQL
  15. Checking multiple columns for one value
  16. What is better in MYSQL count(*) or count(1)?
  17. Delete query not working in mysql
  18. How to insert data to MySQL with auto-incremented column(field)?
  19. How to get the count of each distinct value in a column? [duplicate]
  20. How to enable INNODB in mysql
  21. Bash script to insert values in MySQL
  22. MySQL GROUP BY DateTime +/- 3 seconds
  23. SELECT INTO and “Undeclared variable” error
  24. How to regex in a MySQL query
  25. MySQL 5.6 – DENSE_RANK like functionality without Order By
  26. Syntax error on MERGE statement
  27. SQL (MySQL) vs NoSQL (CouchDB) [closed]
  28. MySQL update statement to store ranking positions
  29. How to convert a varchar column type to date type without losing the dates
  30. MySQL Multiple Joins in one query?

Leave a Comment