I export the table from a DB. I create a copy of it with a different name but the same structure and empty. Then I import the first table into it. Mistake:

#1062 - Duplicate entry '451' for key 'PRIMARY'

Ok, I delete the PRIMARY and AUTO_INCREMENT from the id column, I make the usual INDEX try again. Same. How so? Well, I can’t have a duplicate. I just exported this table from the existing one, I wouldn’t allow mysql to create a duplicate.

  • 1) someone else inserts in parallel 2) id = 0 by accident - Sergey Panasenko
  • Nobody, it is the test table. id = 0 I don’t know ... - RoboNoob
  • Give more information on what the database is than export-import. - Sergey Panasenko
  • I do not know what else to give, the usual table without foreign keys in MySQL, the usual phpmyadmin where import, export is used - RoboNoob am
  • In the export file, the key 451 was searched, exactly once? - Sergey Panasenko

0