14,970
edits
Export MySQL query to Excel file: Difference between revisions
Jump to navigation
Jump to search
m
→Step 1: Export the MySQL query -> CSV file
| Line 37: | Line 37: | ||
Condition 1: If the rows count of MySQL query is larger than 65,535 rows. You can use MS Excel. | Condition 1: If the rows count of MySQL query is larger than 65,535 rows. You can use MS Excel. | ||
* | * Cell contains return symbol should be replaced. | ||
Condition 2: If the rows count of MySQL query is less than 65,535 rows. You can use [https://zh-tw.libreoffice.org/discover/calc/ LibreOffice Calc] & MS Excel. | Condition 2: If the rows count of MySQL query is less than 65,535 rows. You can use [https://zh-tw.libreoffice.org/discover/calc/ LibreOffice Calc] & MS Excel. | ||