Duplicate entry

# USE AUTO_INCREMENT
AUTO_INCREMENT

Duplicate entry

drop table And id column make auto increment the import data

Duplicate entry

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', ...)

-1

Similar codes

1 vote151 views1 answer
Delete specific row in sql
SQL
0 vote138 views2 answers
Plan d'exécution requete oracle autotracer
SQL
1 vote179 views1 answer
Postgresql where datetrunc month and year equal
SQL
1 vote134 views1 answer
Sql trigger before delete
SQL
3 votes151 views4 answers
ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client vs code
SQL
0 vote129 views1 answer
How to Remove milliseconds from Date time
SQL
0 vote152 views1 answer
Xamarin sql lite create table if not exist
SQL
3 votes175 views2 answers
@sqlresultsetmapping
SQL
0 vote149 views1 answer
WHERE not regex in SQL
SQL
2 votes137 views3 answers
Install mysql workbench ubuntu 20.04 terminal
SQL