14,970
edits
Export MySQL query to Excel file: Difference between revisions
Jump to navigation
Jump to search
m
→Mysql management tools
(→Mysql management tools: + DataGrip) |
|||
| Line 100: | Line 100: | ||
== Mysql management tools == | == Mysql management tools == | ||
''$'' [https://www.jetbrains.com/datagrip/ DataGrip: Cross-Platform IDE for Databases & SQL by JetBrains] v. 2017.2.2 for {{Mac}} 30 days trial | |||
* Import format: Import CSV file into table | |||
* Export format: Export query result set in two ways (1) Export as file/text such as CSV, Json, HTML/XML (2) "Export as queries" update or insert queries<ref>[https://www.jetbrains.com/datagrip/features/importexport.html Import/Export Options From CSV To Database - Features | DataGrip]</ref> {{Gd}} | |||
* Engine supported: MySQL, PostgreSQL, Microsoft SQL Server, Microsoft Azure, Oracle, Amazon Redshift, Sybase, DB2, SQLite, HyperSQL, Apache Derby and H2<ref>[https://www.jetbrains.com/datagrip/features/ Features - DataGrip]</ref> | |||
* Software licenses: Proprietary | |||
''$'' [https://www.sqlprostudio.com/# SQLPro Studio - macOS database management UI] v. 1.0.127 for {{Mac}} | ''$'' [https://www.sqlprostudio.com/# SQLPro Studio - macOS database management UI] v. 1.0.127 for {{Mac}} | ||
* Import format: Import CSV file into table | * Import format: Import CSV file into table | ||
* Export format: Export query result set as CSV, Json, XML | * Export format: Export query result set as CSV, Json, XML | ||
* Engine supported: MySQL, MSSQL, Oracle, PostgreSQL | * Engine supported: MySQL, MSSQL, Oracle, PostgreSQL | ||
* Software licenses: Proprietary | * Software licenses: Proprietary | ||