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

4 votes117 views1 answer
Oracle nls_date_format
SQL
1 vote107 views1 answer
Sql string function update replace
SQL
3 votes105 views1 answer
Postgres count distinct
SQL
17 votes98 views4 answers
Set mysql Password
SQL
0 vote134 views1 answer
Isnull in sqlite
SQL
13 votes110 views3 answers
Insert mysql ifile nto database
SQL
3 votes145 views1 answer
Oracle nextval insert
SQL
0 vote113 views1 answer
Sql server phone constraint
SQL
2 votes107 views1 answer
Copy all values of a column to another column in sql in same table
SQL
10 votes96 views4 answers
Primary key in sql
SQL