14,970
edits
Export MySQL query to Excel file: Difference between revisions
Jump to navigation
Jump to search
→Step 3: Data verification
| Line 85: | Line 85: | ||
# 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}} If 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}} If the CSV is not well-formatted, sometimes the data column after imported to Excel is in wrong position. | ||
# Verify the rows count | |||
#* 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 | #* 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 | #** enclosure character e.g. {{kbd | key=Tab}} key | ||