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 vote98 views1 answer
What is between operator
SQL
0 vote110 views2 answers
Import .sql into postgres db command
SQL
1 vote93 views2 answers
Sql example query
SQL
0 vote101 views1 answer
Mysqlcli how to load external sql file
SQL
1 vote94 views1 answer
Too many connections mysql
SQL
0 vote109 views1 answer
What is server_default = func.now() in sqlalchemy
SQL
19 votes105 views4 answers
Can't connect to local MySQL server through socket '/tmp/mysql.sock'
SQL
0 vote98 views1 answer
Copy Table from SQL to CSV
SQL
-1 vote102 views1 answer
Sql oracle take only last results
SQL
10 votes119 views2 answers
Select nextval from sequence oracle
SQL