Comparison between NavicatforMySQL and MySQLGUITools _ MySQL

Foreword there are many MySQLGUI tools. This article provides a detailed introduction and comparison of the features of NavicatforMySQL and MySQLGUITools. (1) MySQL database management console, a visual interface officially provided by MySQLGUIToolsMySQL, provides four NavicatmysqlGUI

Preface

There are many MySQL GUI Tools. This article provides a detailed introduction and comparison of the features of Navicat for MySQL and MySQL GUI Tools.

(1) MySQL GUI Tools

MySQL database management console, a visual interface officially provided by MySQL, provides four graphical applications, these graphical management tools can greatly improve the efficiency of database management, backup, migration and query. They are:

● MySQL Migration Toolkit
● MySQL Administrator
● MySQL Query Browser
● MySQL Workbench

1. MySQL Query Browser

The MySQL Query Browser is the simplest visualization tool used to create, execute, and optimize SQL queries for the MySQL database server. MySQL Query Browser features:

● The query toolbar navigation button allows you to view the query history and review and execute previous queries. You can save the query and open the query file *. qbquery.
● Use the results window to easily manage multiple queries

Multiple queries are separated by viewing tabs, or displayed in the result window in vertical or horizontal Union. In addition, the explain button can be used to obtain the explanation, and the output is the current query. The Compare button allows you to quickly compare the two query results, allowing you to determine where rows have been inserted, updated, or deleted.

● Script editing and debugging

The script area is characterized by numbers and syntax highlights. In addition, the script debugging button allows you to set breakpoints and control the execution of this statement and script.

● Built-in help

You can view mysql syntax statement syntaxes, functions, and parameters.

2. MySQL Administrator

Mysql Administrator makes it easier for users to manage and monitor your MySQL environment and gain better visibility into the database.

Main features of MySQL Administrator:

● Start/Stop the mysql service
● Health check: view the connection Health real-time graph (connection usage, traffic, number of SQL queries), memory health check (Query Cache Hitrate, Key Efficiency), and status variable (normal, performance, network, executed command, hybrid, new variable), system variable View (common, connection, SQL, memory, table type, new variable)

3. Migration Toolkit

● You can port and copy databases from ms SQL, Oracle, and other databases to Mysql.

4. MySQL Workbench

● Add an EER chart (abbreviation of Extended Entity-Relationship)
● Use the default Schema to create new tables, new views, and other objects
● You can import SQL scripts.

Disadvantages:

● Mysql Query Browser always uses too much memory after several queries.
● When you manually install MySQL GUI Tools 5.0, you can name the Directory in Chinese or place it on the desktop to execute MySQL Query Browser. this problem occurs in the Chinese system :..... mySQL GUI Tools 5.0 \ XML \ mysqlqb_functions.xml (error
● There are not many Chinese introductions and materials.
● Too few formats are supported for import and export.