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 vote312 views1 answer
Mysql 8 geo to json
SQL
23 votes333 views5 answers
Sql substring
SQL
0 vote294 views2 answers
Starting mysql service from mac
SQL
2 votes303 views2 answers
Postgresql search all tables for column name
SQL
0 vote313 views3 answers
How to increase size of column in sql
SQL
0 vote314 views1 answer
Mysql a from on this page has
SQL
0 vote301 views1 answer
Select multiple row from primary key sql
SQL
1 vote287 views1 answer
Org.h2.jdbc.jdbcsqlsyntaxerrorexception table not found
SQL
0 vote291 views1 answer
Export partttion and import in oracle
SQL
2 votes293 views1 answer
Add new column not null sql server
SQL