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

by

The main reason why the error has been generated is because there is already an existing value of 1 for the column ID in which you define it as PRIMARY KEY (values are unique) in the table you are inserting.

Why not set the column ID as AUTO_INCREMENT?

CREATE  TABLE IF NOT EXISTS `PROGETTO`.`UFFICIO-INFORMAZIONI` (
  `ID` INT(11) NOT NULL AUTO_INCREMENT,
  `viale` VARCHAR(45) NULL ,
   .....

and when you are inserting record, you can now skip the column ID

INSERT INTO `PROGETTO`.`UFFICIO-INFORMAZIONI` (`viale`, `num_civico`, ...) 
VALUES ('Viale Cogel ', '120', ...)

More Related Contents:

  1. Calculate date range between two rows
  2. Authentication plugin ‘caching_sha2_password’ cannot be loaded
  3. Error Code: 2013. Lost connection to MySQL server during query
  4. String concatenation in MySQL
  5. MySQL: How to allow remote connection to mysql
  6. Access Denied for User ‘root’@’localhost’ (using password: YES) – No Privileges?
  7. MySQL Foreign Key Error 1005 errno 150 primary key as foreign key
  8. MySQL error code: 1175 during UPDATE in MySQL Workbench
  9. Cannot connect to Database server (mysql workbench)
  10. Problems with contenttypes when loading a fixture in Django
  11. How to connect mysql workbench to running mysql inside docker?
  12. MySQL Workbench: How to keep the connection alive
  13. How do I retrieve my MySQL username and password?
  14. MySQL 8.0.11 error connect to caching_sha2_password the specified module could not be found
  15. MySQL error 1022 when creating table
  16. Is there a naming convention for MySQL?
  17. Can’t connect to MySQL server on ‘127.0.0.1’ (10061) (2003)
  18. MySQL Errno 150
  19. MySQL Workbench: Error in query (1064): Syntax error near ‘VISIBLE’ at line 1
  20. error code 1292 incorrect date value mysql
  21. Order by FIELD in MYSQL
  22. SELECT INTO Variable in MySQL DECLARE causes syntax error?
  23. Accessing a mysql database from external host/ip? (ie: mysql workbench)
  24. mySQL query to search all tables within a database for a string?
  25. Create a new database with MySQL Workbench
  26. Errno 121, duplicate key on write or update?
  27. How can I enable the federated engine in mysql after installation?
  28. MySQL and Check Constraints
  29. How to optimise MySQL queries based on EXPLAIN plan
  30. MySQL behavior of ON DUPLICATE KEY UPDATE for multiple UNIQUE fields

Leave a Comment