13,468
edits
MySQL commands: Difference between revisions
Jump to navigation
Jump to search
→Troubleshooting of MySQL
| Line 94: | Line 94: | ||
solution: | solution: | ||
* {{kbd | key=<nowiki>-h localhost</nowiki>}} 變數值改成指定 {{kbd | key=<nowiki>-h 127.0.0.1</nowiki>}} | * {{kbd | key=<nowiki>-h localhost</nowiki>}} 變數值改成指定 {{kbd | key=<nowiki>-h 127.0.0.1</nowiki>}} | ||
==== Navicat err: [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: | |||
* exceeds the Excel Worksheet size: 1,048,576 rows | |||
solution: | |||
* LIMIT the rows of MySQL query | |||
=== further reading === | === further reading === | ||