14,962
edits
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. | * '''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 == | ||