Import SQL data using phpMyAdmin Error: #1062-duplicate entry ' ...

To import SQL data using phpMyAdmin error:

MySQL return: #1062-duplicate entry ' 0 ' for key ' PRIMARY '

This error occurs because the primary key of the data is duplicated, and the record shown in the error message has been imported ~ ~

Because the data update will be manually inserted in the corresponding location of a single or multiple pieces of data, so the data through the collation of the primary key after the self-increment is emptied, easy to manually insert data. In this way, when using phpMyAdmin to import SQL data, the above error will be reported, the solution is as follows: When importing data in the format of the import file do not tick do not give 0 value to use self-increment (auto_increment), This will automatically add values to the self-increment primary key when importing data. Of course, there will be no more error, the successful import.

Import SQL data using phpMyAdmin Error: #1062-duplicate entry ' ...