14,962
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 88: | Line 88: | ||
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. | ||
Condition 3: Replace the double quote with double double quote | Condition 3: Replace the double quote with double double quote if the enclosure character is double quote. | ||
Condition 4: (optional) Replace the return character with space character or other character e.g. {{kbd | key = ↵}} ([https://www.compart.com/en/unicode/U+21B5 U+21B5]). SQL query syntax: | Condition 4: (optional) Replace the return character with space character or other character e.g. {{kbd | key = ↵}} ([https://www.compart.com/en/unicode/U+21B5 U+21B5]). SQL query syntax: | ||