匯入表時,結果顯示‘“ERROR 1062 (23000): Duplicate entry '0' for key 'PRIMARY'”,表內容如:
<"11026","guide to mysql 5.7","2008">
<"11028","learning c++","2005">
<"11033","study html","2010">
<"11041","inside vc++","2011">
<"11069","mysql professional","2009">
<"11072","teach yourself javascript","2005">
<"11078","learning mysql","2010">
第一列為關主鍵,雖然都有0,但是每個編碼都不一樣,請教各位是怎么回事呢?感謝!
uj5u.com熱心網友回復:
看看主鍵是啥仔細看看你的資料和表里現在已經有的資料
uj5u.com熱心網友回復:
對應的欄位有重復沖突了uj5u.com熱心網友回復:
你的匯入陳述句是什么? 表結構是什么?uj5u.com熱心網友回復:
與表里面已有資料沖突,或者你進行了多次匯入轉載請註明出處,本文鏈接:https://www.uj5u.com/shujuku/87979.html
標籤:MySQL
