Export MySQL query to Excel file: Difference between revisions

Jump to navigation Jump to search
m
Text replacement - "errerrors.blogspot.tw" to "errerrors.blogspot.com"
m (Text replacement - "errerrors.blogspot.tw" to "errerrors.blogspot.com")
Line 128: Line 128:
=== Data format in result set became string after exported as Excel file===
=== 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 <ref>[https://exceljet.net/formula/convert-text-to-numbers Excel formula: Convert text to numbers | Exceljet]</ref>
* '''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<ref>[https://errerrors.blogspot.tw/2016/12/excel-value-text.html Excel 如何轉換文字格式的日期時間格式 (使用 VALUE, TEXT 函數)]</ref>
* '''Date time''' data types in result set became '''string''' after exported as XLSX file<ref>[https://errerrors.blogspot.com/2016/12/excel-value-text.html Excel 如何轉換文字格式的日期時間格式 (使用 VALUE, TEXT 函數)]</ref>


== Database management tools ==
== Database management tools ==

Navigation menu