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

0 vote249 views1 answer
Backup a table in sql
SQL
0 vote271 views2 answers
Sql trigger difference between for and after
SQL
0 vote273 views1 answer
Create dump file mysql workbench
SQL
1 vote262 views1 answer
Mysql return text after a final full stop
SQL
0 vote261 views2 answers
How to update date in oracle
SQL
0 vote262 views1 answer
How to get table current identity value in sql server
SQL
1 vote253 views1 answer
Sql server find tables referenced foreign key
SQL
1 vote255 views1 answer
Ef core 5.0 usesqlserver not found
SQL
0 vote269 views1 answer
Oracle array
SQL
1 vote272 views1 answer
Postgres power
SQL