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

5 votes359 views1 answer
Oracle nls instance
SQL
7 votes364 views4 answers
Mysql delete older duplicates
SQL
0 vote346 views1 answer
R rmysql connect local database Plugin caching_sha2_password could not be loaded
SQL
1 vote391 views1 answer
Oracle see column type
SQL
0 vote385 views3 answers
Mysql keyword search
SQL
8 votes345 views1 answer
Oracle tablespace datafile max size
SQL
27 votes357 views6 answers
Sql update record
SQL
1 vote368 views1 answer
Update from table tsql
SQL
0 vote330 views1 answer
Raiserror nowait sql server
SQL
0 vote407 views1 answer
Sql alternative to max statement
SQL