Troubleshooting of MySQL errors: Difference between revisions

Jump to navigation Jump to search
Line 322: Line 322:
solution:
solution:
* LIMIT the rows of MySQL query
* LIMIT the rows of MySQL query
== 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)


== Database and Table Operation Errors ==
== Database and Table Operation Errors ==

Navigation menu