14,970
edits
Export MySQL query to Excel file: Difference between revisions
Jump to navigation
Jump to search
→two steps conversion ex: MySQL query -> CSV file -> Excel file
| Line 11: | Line 11: | ||
step (1) MySQL query -> CSV/XLS file | step (1) MySQL query -> CSV/XLS file | ||
* PHPExcel or MySQL client softwares | * PHPExcel or MySQL client softwares | ||
* [http://dev.mysql.com/doc/refman/5.7/en/mysqldump-delimited-text.html MySQL :: MySQL 5.7 Reference Manual :: 8.4.3 Dumping Data in Delimited-Text Format with mysqldump] Required permission ex: {{kbd | key = GRANT FILE ON *.* TO 'user_name'@'localhost';}} | * [http://dev.mysql.com/doc/refman/5.7/en/mysqldump-delimited-text.html MySQL :: MySQL 5.7 Reference Manual :: 8.4.3 Dumping Data in Delimited-Text Format with mysqldump] | ||
** Required permission ex: {{kbd | key = GRANT FILE ON *.* TO 'user_name'@'localhost';}} If you met the following error message: | |||
<pre> | |||
mysqldump: Got error: 1045: Access denied for user 'user_name'@'localhost' (using password: YES) when executing 'SELECT INTO OUTFILE' | |||
</pre> | |||
step (2) CSV --> XLSX or XLS --> XLSX. | step (2) CSV --> XLSX or XLS --> XLSX. | ||