Database management tools: Difference between revisions
update HeidiSQL |
|||
| (5 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
Comparison of database management tools | Comparison of database management tools e.g. import Excel data into a MySQL database | ||
== Lists of database tools == | == Lists of database tools == | ||
| Line 33: | Line 33: | ||
''$'' [https://www.webyog.com/product/sqlyog SQLyog] Ultimate v. 12.4.3 for {{Win}} | ''$'' [https://www.webyog.com/product/sqlyog SQLyog] Ultimate v. 12.4.3 for {{Win}} | ||
* Import format: Import Access, Excel, CSV, XML file & ODVC source into table<ref>[http://sqlyogkb.webyog.com/article/271-import-external-data Import External Data - SQLyog Knowledge Base]</ref> | * Import format: Import Access, Excel, CSV, XML file & ODVC source into table<ref>[http://sqlyogkb.webyog.com/article/271-import-external-data Import External Data - SQLyog Knowledge Base]</ref> | ||
* Export format: Export query result set as CSV, Json, HTML/XML, '''Excel XML''' file<ref>[http://sqlyogkb.webyog.com/article/215-export-data Export Data - SQLyog Knowledge Base]</ref><ref>[http://sqlyogkb.webyog.com/article/199-exporting-resultset Exporting Resultset - SQLyog Knowledge Base]</ref> | * Export format: Export query result set as CSV, Json, HTML/XML, '''Excel XML''' file<ref>[http://sqlyogkb.webyog.com/article/215-export-data Export Data - SQLyog Knowledge Base]</ref><ref>[http://sqlyogkb.webyog.com/article/199-exporting-resultset Exporting Resultset - SQLyog Knowledge Base]</ref> (You may convert '''Excel XML''' to Excel .XLSX file by using Microsoft Excel on {{Win}} or [https://zh-tw.libreoffice.org/discover/calc/ LibreOffice Calc]) | ||
* Specify Field and Row Terminators: available | * Specify Field and Row Terminators: available | ||
* Engine supported: MySQL & MariaDB<ref>[http://sqlyogkb.webyog.com/article/166-what-is-sqlyog What is SQLyog - SQLyog Knowledge Base]</ref> | * Engine supported: MySQL & MariaDB<ref>[http://sqlyogkb.webyog.com/article/166-what-is-sqlyog What is SQLyog - SQLyog Knowledge Base]</ref> | ||
| Line 68: | Line 68: | ||
* Comments: {{exclaim}} When I tried to export the query result set as XLS file but no file was generated! | * Comments: {{exclaim}} When I tried to export the query result set as XLS file but no file was generated! | ||
[https://www.sequelpro.com/ Sequel Pro] for {{Mac}} | [https://www.sequelpro.com/ Sequel Pro] v. 1.1.2 for {{Mac}} | ||
* Import format: CSV, SQL | * Import format: CSV, SQL | ||
* Export format: (1) Export query result set as CSV/XML file. (2) Export table as SQL/CSV/XML and DOT (ERD Database Structure) file. | * Export format: (1) Export query result set as CSV/XML file. (2) Export table as SQL/CSV/XML and DOT (ERD Database Structure) file. | ||
| Line 74: | Line 74: | ||
* SQL syntax checker: | * SQL syntax checker: | ||
* Engine supported: MySQL<ref>[https://sequelpro.com/docs/get-started/get-connected Getting Connected]</ref> | * Engine supported: MySQL<ref>[https://sequelpro.com/docs/get-started/get-connected Getting Connected]</ref> | ||
* Software licenses: | * Software licenses: [https://github.com/sequelpro/sequelpro/blob/master/LICENSE MIT LICENSE]. Source code available on [https://github.com/sequelpro/sequelpro github]. | ||
* Data type of cell value: | * Data type of cell value: | ||
* Comments: | * Comments: | ||
''$'' [https://www.jetbrains.com/datagrip/ DataGrip: Cross-Platform IDE for Databases & SQL by JetBrains] v. | ''$'' [https://www.jetbrains.com/datagrip/ DataGrip: Cross-Platform IDE for Databases & SQL by JetBrains] v. 2020. for {{Win}} & {{Mac}} 30 days trial | ||
* Import format: Import CSV file into table | * Import format: Import CSV, TSV or Pipe-separated file into table | ||
* Export format: Export query result set in two ways (1) Export as file 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}} | * Export format: Export query result set in two ways (1) Export as file such as CSV, Json, HTML/XML, Excel (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}} | ||
* Specify Field and Row Terminators: | * Specify Field and Row Terminators: | ||
* 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> | * 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> | ||
| Line 206: | Line 206: | ||
<references /> | <references /> | ||
[[Category:Data Science]] [[Category:Excel]] [[Category:MySQL]] [[Category:Tool]] | [[Category:Data Science]] [[Category:Database]] [[Category:Excel]] [[Category:MySQL]] [[Category:Tool]] | ||