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

3 votes149 views1 answer
Postgresql where current year
SQL
0 vote184 views1 answer
Hoq to import database source
SQL
4 votes167 views3 answers
Mysql varchar length
SQL
24 votes202 views6 answers
Alter table name sql
SQL
2 votes199 views1 answer
Merge firstname and lastname in sql oracle
SQL
5 votes177 views3 answers
How to remove unique key constraint in mysql
SQL
0 vote176 views1 answer
Restore backupfile discourse
SQL
0 vote201 views1 answer
Psql generate id in existing database
SQL
0 vote187 views1 answer
Drop-toys-table
SQL
3 votes225 views2 answers
How to View column names of a table in SQL
SQL