14,970
edits
Export MySQL query to Excel file: Difference between revisions
Jump to navigation
Jump to search
m
→Step 3: Data verification
| Line 83: | Line 83: | ||
==== Step 3: Data verification ==== | ==== Step 3: Data verification ==== | ||
# Verify the data rows count: Equal to the rows count of MySQL query. Not equal to 65,535 rows or less than the rows count of MySQL query. | # Verify the data rows count: Equal to the rows count of MySQL query. '''Not''' equal to 65,535 rows or less than the rows count of MySQL query. | ||
# Verify the data column is in correct position | # 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. | #* {{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. | ||