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 vote361 views1 answer
Implicit inner join table alias
SQL
0 vote342 views1 answer
Redudancy in SQL
SQL
0 vote353 views1 answer
This week mysql
SQL
0 vote371 views1 answer
Intellij idea add mysql connector
SQL
18 votes345 views6 answers
Create table mysql
SQL
0 vote348 views1 answer
Oserror mysql_config not found virtualenv
SQL
0 vote347 views1 answer
Mysql changer nom table
SQL
0 vote341 views1 answer
Mysql workbench procedure
SQL
1 vote370 views2 answers
Identify rows with 2 same column value and delete duplicate mysql
SQL
0 vote360 views1 answer
Value of sold product using having and group by in sql
SQL