Troubleshooting of MySQL errors: Difference between revisions
Jump to navigation
Jump to search
→Navicat error: [Exp] OLE error 800A03EC
Tags: Mobile edit Mobile web edit |
|||
| Line 539: | Line 539: | ||
solution: | solution: | ||
* LIMIT the rows of MySQL query | * LIMIT the rows of MySQL query | ||
== Navicat: 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) | |||
== PHP Fatal Error: Allowed Memory Size Exhausted when import SQL.GZ file using adminer == | == PHP Fatal Error: Allowed Memory Size Exhausted when import SQL.GZ file using adminer == | ||