Export MySQL query to Excel file: Difference between revisions

Export MySQL query to Excel file (edit)

6 bytes removed , 30 October 2017

14,970

edits

@@ Line 102: / Line 102: @@
 === Data format in result set became string after exported as Excel file===
-* '''Number''' data types in result set became '''string''' after exported as XLSX file: [https://exceljet.net/formula/convert-text-to-numbers Excel formula: Convert text to numbers | Exceljet]
+* '''Number''' data types in result set became '''string''' after exported as XLSX file <ref>[https://exceljet.net/formula/convert-text-to-numbers Excel formula: Convert text to numbers | Exceljet]</ref>
-* '''Date time''' data types in result set became '''string''' after exported as XLSX file: [https://superuser.com/questions/274494/convert-text-string-to-date-time-format microsoft excel - convert text string to date/time format - Super User] ''unverified''
+* '''Date time''' data types in result set became '''string''' after exported as XLSX file<ref>[https://errerrors.blogspot.tw/2016/12/excel-value-text.html Excel 如何轉換文字格式的日期時間格式 (使用 VALUE, TEXT 函數)]</ref>
 == Database management tools ==