Error Code 1062 Duplicate entry 1 for key PRIMARY

Question

I have a problem on this error message  when i try this   INSERT INTO  PROGETTO   UFFICIO-INFORMAZIONI    ID    viale    num civico      data apertura    data chiusura    orario apertura    orario chiusura     telefono    mail    web    Nome-paese    Comune    VALUES  1   Viale Cogel     120    2012-05-21    2012-09-30    08 00    23 30    461801243    informazioni bolzano it    Bolzanoturismo it    Bolzano    BZ     Error Code  1062  Duplicate entry  1  for key  PRIMARY   I haven t auto increment data  PLEASE HELP me     This is the table related  UFFICIO-INFORMAZIONI  CREATE  TABLE IF NOT EXISTS  PROGETTO   UFFICIO-INFORMAZIONI       ID  INT 11  NOT NULL      viale  VARCHAR 45  NULL      num civico  VARCHAR 5  NULL      data apertura  DATE NULL      data chiusura  DATE NULL      orario apertura  TIME NULL      orario chiusura  TIME NULL      telefono  VARCHAR 15  NULL      mail  VARCHAR 100  NULL      web  VARCHAR 100  NULL      Nome-paese  VARCHAR 45  NOT NULL      Comune  CHAR 2  NOT NULL     PRIMARY KEY   ID       INDEX  Nome paese    Nome-paese  ASC      INDEX  Comune    Comune  ASC      CONSTRAINT  Nome paese      FOREIGN KEY   Nome-paese        REFERENCES  PROGETTO   PAESE    Nome-paese        ON DELETE NO ACTION     ON UPDATE CASCADE    CONSTRAINT  Comune      FOREIGN KEY   Comune        REFERENCES  PROGETTO   PAESE    Comune        ON DELETE NO ACTION     ON UPDATE CASCADE  ENGINE   InnoDB   INSERT INTO   INSERT INTO  PROGETTO   UFFICIO-INFORMAZIONI    ID    viale    num civico    data apertura    data chiusura    orario apertura    orario chiusura    telefono    mail    web    Nome-paese    Comune   VALUES  1   Viale Cogel     120    2012-05-21    2012-09-30    08 00    23 30    461801243    informazioni bolzano it    Bolzanoturismo it    Bolzano    BZ        INSERT INTO  PROGETTO   UFFICIO-INFORMAZIONI    ID    viale    num civico    data apertura    data chiusura    orario apertura    orario chiusura    telefono    mail    web    Nome-paese    Comune   VALUES  2   Via Olmo    45    2012-05-01    2012-09-30    08 00    23 30    393495169301    informazioni lech it    Lechinformation it    Lech    BZ        INSERT INTO  PROGETTO   UFFICIO-INFORMAZIONI    ID    viale    num civico    data apertura    data chiusura    orario apertura    orario chiusura    telefono    mail    web    Nome-paese    Comune   VALUES  3   Via Quercia    37    2012-05-11    2012-09-30    08 00    23 30    393381679321    info trento it    Trentoinformaiozni it    Trento    TN        INSERT INTO  PROGETTO   UFFICIO-INFORMAZIONI    ID    viale    num civico    data apertura    data chiusura    orario apertura    orario chiusura    telefono    mail    web    Nome-paese    Comune   VALUES  4   Via Atene    76    2012-06-01    2012-09-15    08 00    23 30    39349361345    info sanmartinodicastrozza it    SanMartino it    San Martino di Castrozza    TN        INSERT INTO  PROGETTO   UFFICIO-INFORMAZIONI    ID    viale    num civico    data apertura    data chiusura    orario apertura    orario chiusura    telefono    mail    web    Nome-paese    Comune   VALUES  5   Via Salice    45    2012-05-01    2012-09-20    08 00    23 30   NULL   info pejo it    Pejoturismo it    Pejo    TN        INSERT INTO  PROGETTO   UFFICIO-INFORMAZIONI    ID    viale    num civico    data apertura    data chiusura    orario apertura    orario chiusura    telefono    mail    web    Nome-paese    Comune   VALUES  6   Piazza Sempreverde    34    2012-05-15    2012-09-15    08 00    23 30    392516789    info ortisei it    Ortisei it    Ortisei    BZ

User · Answer

When I get this kind of error I had to update the data type by a notch  For Example  if I have it as  tiny int  change it to  small int    Nita

User · Answer

The problem is related with your file - you are trying to create a DB using a copy - at the top of your file you will find something like this   CREATE DATABASE IF NOT EXISTS  THE NAME OF YOUR DB  DEFAULT CHARACTER SET latin1 COLLATE latin1 general ci  USE  THE NAME OF YOUR DB    and I m sure that you already have a DB with this name - IN THE SAME SERVER - please check  Just change the name OR ERASE THIS LINE

User · Answer

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

User · Answer

If you are trying to populate a table from a SQL dump  make sure that the table listed in the  INSERT INTO  statements of the dump is the same one you are trying to populate  Opening  MyTable  and importing with a SQL dump will throw exactly that kind of error if the dump is trying to put entries into  MyOtherTable   which may already have entries

User · Answer

Also check your triggers   Encountered this with a history table trigger which tried to insert the main table id into the history table id instead of the correct hist-table source id column   The update statement did not touch the id column at all so took some time to find   UPDATE source table SET status   0    The trigger tried to do something similar to this   FOR EACH ROW BEGIN     INSERT INTO  history table    action   id   status   time created       VALUES  update   NEW id  NEW status  NEW time created   END    Was corrected to something like this   FOR EACH ROW BEGIN     INSERT INTO  history table    action   source id   status   time created       VALUES  update   NEW id  NEW status  NEW time created   END

User · Answer

I just encountered the same issue but here it seemed to come from the fact that I declared the ID-column to be UNsigned and that in combination with an ID-value of  0   zero  caused the import to fail     So by changing the value of every ID  PK-column  that I d declared  0  and every corresponding FK to the new value  my issue was solved

User · Answer

If you have a new database and you make a fresh clean import  the problem may come from inserting data that contains a  0  incrementation and this would transform to  1  with AUTO INCREMENT and cause this error   My solution was to use in the sql import file   SET SESSION sql mode  NO AUTO VALUE ON ZERO

User · Answer

If you are using PHPMyAdmin You can be solved this issue by doing this      CAUTION  Don t use this solution if you want to maintain existing   records in your table    Step 1  Select database export method to custom     Step 2  Please make sure to check truncate table before insert in data creation options     Now you are able to import this database successfully

[mysql] Error Code: 1062. Duplicate entry '1' for key 'PRIMARY'

Examples related to mysql

Examples related to mysql-workbench

Examples related to error-code

Examples related to mysql-error-1062