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

2 votes176 views2 answers
Postgresql search all tables for column name
SQL
1 vote178 views1 answer
Create new table from old table with data
SQL
3 votes185 views1 answer
Increment integer in table sql
SQL
2 votes177 views1 answer
Oracle virtual column
SQL
3 votes161 views1 answer
How to remove characters from string in mysql
SQL
3 votes159 views1 answer
Oracle function
SQL
11 votes184 views5 answers
How to install sqlite3 python
SQL
1 vote191 views2 answers
Postgresql check privileges on schema
SQL
0 vote186 views1 answer
Sql get count without group by
SQL
0 vote175 views1 answer
Running query in redshift
SQL