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 vote149 views1 answer
How to switch user in mysql
SQL
3 votes168 views1 answer
Select table column in sql
SQL
0 vote146 views1 answer
Case when with count and combining similar values in sql
SQL
0 vote154 views4 answers
Creating a comment and reply system PHP and MySQL
SQL
3 votes157 views3 answers
Update join
SQL
-1 vote181 views1 answer
SQL SERVER microsoft How to Add Column at Specific Location in Table
SQL
8 votes155 views2 answers
Between operator
SQL
0 vote154 views1 answer
How to find columns with null values in sql
SQL
0 vote149 views1 answer
Luu ckeditor vao mysql
SQL
0 vote149 views1 answer
Acutal month year
SQL