14,962
edits
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://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}} | ||
* [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. 30 days trial | |||
* ''$'' [https://www.navicat.com/cht Navicat GUI] for {{Win}} & {{Mac}} | * ''$'' [https://www.navicat.com/cht Navicat GUI] for {{Win}} & {{Mac}} | ||