15,024
edits
Troubleshooting of MySQL errors: Difference between revisions
Jump to navigation
Jump to search
→Miscellaneous Tool-Specific Errors
| Line 576: | Line 576: | ||
Solution: | Solution: | ||
* [https://errerrors.blogspot.com/2023/11/blog-post.html 解決 NaviCat 匯入 Excel 檔案到資料庫，出現資料總筆數不一致的問題] (written in Mandarin) | * [https://errerrors.blogspot.com/2023/11/blog-post.html 解決 NaviCat 匯入 Excel 檔案到資料庫，出現資料總筆數不一致的問題] (written in Mandarin) | ||
=== Navicat error: [Exp] OLE error 800A03EC === | |||
error message: | |||
<pre> | |||
[Msg] [Exp] Export to - test.xlsx | |||
[Err] [Row1048576] [Exp] OLE error 800A03EC | |||
[Err] [Row1048577] [Exp] OLE error 800A03EC | |||
[Err] [Row1048578] [Exp] OLE error 800A03EC | |||
[Err] [Row1048579] [Exp] OLE error 800A03EC | |||
</pre> | |||
cause: | |||
* Rows count of results exceed the limit of [[Microsoft Excel]] Worksheet size: 1,048,576 rows | |||
solution: | |||
* LIMIT the rows of MySQL query | |||
== References == | == References == | ||