即使没有重复的条目php我的管理员显示重复的条目错误

Question

I am trying to import well worked database to my phpmyadmin, though there is no duplicate entry for primary key. Since I have made auto increment for primary key, there is no chance for duplicate entry for it.I am using mysql 5.6.11 version.

Answer 1

there may be to reasons for that

1)let there are two tables in other table the first one table primary key is using as foreign key when you are importing the data the insert statements must be in order so that the table which primary key is using in another table must be insert data first

2)truncate the table and try import again if the same error occur then the first step follow that