Export MySQL query to Excel file: Difference between revisions

Export MySQL query to Excel file (edit)

80 bytes added , 28 September 2016

m

14,970

edits

@@ Line 32: / Line 32: @@
 # Verify the data column is in correct position
 #* {{exclaim}} Because the CSV is not well-formatted, sometimes the data column after imported to Excel is in wrong position. If the data size is less than 65,535 rows, convert CSV to Excel/XLS by [https://zh-tw.libreoffice.org/discover/calc/ LibreOffice Calc] is recommended.
-#* 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 and return symbol to separate different data row.
+#* 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
+#** escape the enclosure character e.g. {{kbd | key=<nowiki>"</nowiki>}}
+#** return symbol to separate different data row.
 == Technical issues: If it costs too much time to convert to Excel file ==