Export MySQL query to Excel file: Difference between revisions
Jump to navigation
Jump to search
→One step conversion: ex MySQL query -> Excel file
| Line 54: | Line 54: | ||
=== One step conversion: ex MySQL query -> Excel file === | === One step conversion: ex MySQL query -> Excel file === | ||
Methods of exporting MySQL query -> XLS/XLSX file: PHP scripts or other MySQL client softwares e.g. | Methods of exporting MySQL query -> XLS/XLSX file: PHP scripts or other MySQL client softwares e.g. | ||
* [https://www.spectralcore.com/fullconvert Full Convert Enterprise | * [https://www.spectralcore.com/fullconvert Full Convert Enterprise]: allows easy copying of tables and data between 40 or so supported databases. It will create all the tables, copy all of your data, then create indexes and foreign keys. | ||
]: allows easy copying of tables and data between 40 or so supported databases. It will create all the tables, copy all of your data, then create indexes and foreign keys. | |||
* [https://phpexcel.codeplex.com/ PHPExcel]: PHP scripts | * [https://phpexcel.codeplex.com/ PHPExcel]: PHP scripts | ||
* [https://www.quest.com/products/toad-for-mysql/ Toad for MySQL] for {{Win}} | * [https://www.quest.com/products/toad-for-mysql/ Toad for MySQL] for {{Win}} | ||