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 vote211 views1 answer
Alter table myisam to innodb
SQL
0 vote221 views1 answer
Get the Domain Name, Page Name and Query Parameter from a URL
SQL
1 vote208 views2 answers
Sql where keyword
SQL
0 vote231 views1 answer
Create table with primary key and foreign key in sql server
SQL
1 vote250 views1 answer
Sql random sampling per group
SQL
1 vote227 views1 answer
Sysdate in sql
SQL
0 vote212 views3 answers
Mysqli count down
SQL
0 vote242 views1 answer
In query in sql
SQL
5 votes267 views1 answer
Oracle ora-00054 find
SQL
0 vote205 views1 answer
Mysql select all table that have field names
SQL