First I would like to thank google translate, because I can not speak English, Hopefully that experienced the same error can be helped by this article.
If you encounter errors like this mysql error, "MySQL import error 1068 - Multiple primary key defined, ERROR 1062 (23000) at line 5: Duplicate entry '1' for key 'PRIMARY', ERROR 1062 (23000) at line 52122: Duplicate entry '1' for key 'PRIMARY', Error Code: 1062. Duplicate entry 'PRIMARY', Error 1062. Duplicate entry in mysql, MySQL error - #1062 - Duplicate entry ' ' for key 2, Error Code: 1062. Duplicate entry '1' for key 'PRIMARY'"
The error is caused at the time of export mysql database. What we need to do is fix several options when exporting a file mysql. Please see the picture below. I use phpmyadmin to export the database.
![Multiple primary key defined Error 1062 Duplicate entry 2 Multiple primary key defined Error 1062 Duplicate entry 2](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgP1C2tUDtzh24rP9PTuA_UjxxLvYVFKmSkj-32bhPPzuCRwwKZX4QHBfIGCmojPDaqmELtPAZ-p8JK2bAJ21fNEjryStOQ3tk8utVfJIVbL-REoQkjOw_JrRGk4yHTlvanrrng13McIfGx/s320/Multiple+primary+key+defined+Error+1062+Duplicate+entry+1.png) |
1 |
![Multiple primary key defined Error 1062 Duplicate entry 2 Multiple primary key defined Error 1062 Duplicate entry 2](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiHAaGZA444vkOGsgeki2xxBSauD7FC_0F7Fsxf7MGy6yjVd0t8IdR-bp5blTgjbwyrK8y9RbnTBjhenGOlW5CeArQHt6WrH4ku092vHwBT1n0aHYFYzQ1ISHohbxL-k4Xrn-uBIf9aZMqy/s320/Multiple+primary+key+defined+Error+1062+Duplicate+entry+2.png) |
2 |
The problem I am done with this at all, it's your turn to try. Good luck.
Jika artikel ini kurang enak dimakan, salahkan Google Translate. :D
0 Response to "[SOLVED] Error 1062 Mysql Duplicate Entry Primary"
Posting Komentar