15,024
edits
Troubleshooting of MySQL errors: Difference between revisions
Jump to navigation
Jump to search
→Miscellaneous Tool-Specific Errors
| Line 584: | Line 584: | ||
Open the command line with administrative privileges. (How to: [https://www.howtogeek.com/194041/how-to-open-the-command-prompt-as-administrator-in-windows-8.1/ How to Open the Command Prompt as Administrator in Windows 8 or 10]) | Open the command line with administrative privileges. (How to: [https://www.howtogeek.com/194041/how-to-open-the-command-prompt-as-administrator-in-windows-8.1/ How to Open the Command Prompt as Administrator in Windows 8 or 10]) | ||
=== Navicat error: Import data mismatch === | |||
Error: | |||
When importing an Excel file into a MySQL database using Navicat, there is an issue with the total number of records not matching. Solution: Delete blank rows and check for any duplicate primary key data. | |||
Solution: | |||
* [https://errerrors.blogspot.com/2023/11/blog-post.html 解決 NaviCat 匯入 Excel 檔案到資料庫，出現資料總筆數不一致的問題] (written in Mandarin) | |||
== References == | == References == | ||