14,970
edits
Export MySQL query to Excel file: Difference between revisions
Jump to navigation
Jump to search
→Two steps conversion ex: MySQL query -> CSV file -> Excel file
m (→Tools) |
|||
| Line 49: | Line 49: | ||
#* If the data size is larger than 65,535 rows, Adjust the MySQL query to avoid the column value contains the | #* If the data size is larger than 65,535 rows, Adjust the MySQL query to avoid the column value contains the | ||
#** enclosure character e.g. {{kbd | key=Tab}} key | #** enclosure character e.g. {{kbd | key=Tab}} key | ||
#** escape the enclosure character e.g. {{kbd | key=<nowiki>"</nowiki>}} | #** escape the enclosure character e.g. {{kbd | key=<nowiki>"</nowiki>}} become {{kbd | key=<nowiki>""</nowiki>}} | ||
#** return symbol to separate different data row. | #** return symbol to separate different data row. | ||