Database management tools - Revision history

Unknown user: /* 64 bit OS architecture */

2022-07-29T06:03:06Z

64 bit OS architecture

← Older revision		Revision as of 14:03, 29 July 2022
Line 79:		Line 79:

	''$'' [https://www.jetbrains.com/datagrip/ DataGrip: Cross-Platform IDE for Databases & SQL by JetBrains] v. 2020. for {{Win}} & {{Mac}} 30 days trial		''$'' [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, 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}}		* 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:

Unknown user at 07:42, 6 October 2021

2021-10-06T07:42:38Z

← Older revision		Revision as of 15:42, 6 October 2021
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]]

Unknown user at 02:02, 12 August 2021

2021-08-12T02:02:44Z

← Older revision		Revision as of 10:02, 12 August 2021
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 ==

Unknown user: /* 64 bit OS architecture */

2021-02-07T07:13:40Z

64 bit OS architecture

← Older revision		Revision as of 15:13, 7 February 2021
Line 78:		Line 78:
	* Comments:		* Comments:

	''$'' [https://www.jetbrains.com/datagrip/ DataGrip: Cross-Platform IDE for Databases & SQL by JetBrains] v. ~~2017~~.~~2.3~~ for {{Win}} & {{Mac}} 30 days trial		''$'' [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 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>

Unknown user: /* 64 bit OS architecture */

2020-03-01T07:24:34Z

64 bit OS architecture

← Older revision		Revision as of 15:24, 1 March 2020
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>

Planetoid: /* 64 bit OS architecture */

2019-01-18T06:37:00Z

64 bit OS architecture

← Older revision		Revision as of 14:37, 18 January 2019
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: ~~Proprietary~~		* 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:

Planetoid: update HeidiSQL

2019-01-18T03:37:36Z

update HeidiSQL

@@ Line 21: / Line 21: @@
 * Data type of cell value:
 * Comments: Quick to export large data (rows count exceed 10,000 rows) {{Gd}}
 ''$'' [https://www.webyog.com/product/sqlyog SQLyog] Ultimate v. 12.4.3 for {{Win}}
@@ Line 112: / Line 121: @@
 * Engine supported: MySQL
 * Software licenses: Proprietary
 * Data type of cell value:
 * Comments:

Planetoid: /* Further reading */

2019-01-11T06:47:11Z

Planetoid at 06:45, 11 January 2019

2019-01-11T06:45:12Z

← Older revision		Revision as of 14:45, 11 January 2019
Line 201:		Line 201:
	* [[Export MySQL query to Excel file]]		* [[Export MySQL query to Excel file]]
	* [[SQL syntax debug]]		* [[SQL syntax debug]]
			* [[NoSQL management tools]]]

	== References ==		== References ==

Planetoid: /* Architecture independent */

2018-11-05T08:58:31Z

Architecture independent

← Older revision		Revision as of 16:58, 5 November 2018
Line 161:		Line 161:


	=== Architecture independent ===		=== Architecture independent (using browser) ===
	[https://www.phpmyadmin.net/ phpMyAdmin]		[https://www.phpmyadmin.net/ phpMyAdmin]
	* Import format:		* Import format:

← Older revision		Revision as of 14:47, 11 January 2019
Line 201:		Line 201:
	* [[Export MySQL query to Excel file]]		* [[Export MySQL query to Excel file]]
	* [[SQL syntax debug]]		* [[SQL syntax debug]]
	* [[NoSQL management tools]]]		* [[NoSQL management tools]]

	== References ==		== References ==