Navicat for MySQL and MySQL GUI tools function comparison

One, MySQL GUI Tools

MySQL official provides a visual interface to the MySQL database management console, provides four graphical applications, these graphical management tools can greatly improve database management, backup, migration and query efficiency. 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 for creating, executing, and optimizing SQL queries for MySQL database servers. MySQL Query Browser Main features:

The query toolbar navigation buttons allow you to browse through the history of the query and review and rerun previous queries. You can save the query and open the query file *.qbquery.

Easily manage multiple queries with the results window

Compare multiple queries displayed in the results window by viewing tab-delimited, or vertical or horizontal unions. In addition, the interpretation button can be used to get an explanation of the output for the current query. The comparison button allows you to quickly compare the results of two queries, allowing you to determine where rows have been inserted, updated, or deleted.

Script Editing and debugging

The scripting area is characterized by numbering and syntax highlighting. In addition, the Script Debug button allows you to set breakpoints and control the execution of the statement and script.

Built-in Help

Instantly help you get selected objects, parameters, and functions, you can view the MySQL syntax statement syntax, functions, 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.

MySQL Administrator features the main features:

Start/stop MySQL service

Health view: Connect Health Real-time graph view (connection usage, traffic, SQL query number), Memory Health view (query Cache hitrate,key efficiency), state variable view (normal, performance, network, execute command, mix, new variable), System variable view (normal, connection, SQL, memory, table type, new variable)

3. Migration Toolkit

You can copy the database to MySQL from a database such as Ms Sql,oracle.

4. MySQL Workbench

Add EER chart (abbreviation for Extended entity-relationship)

Using the default schema, creating new tables, new views, and so on

You can import SQL scripts

Disadvantages:

Mysql Query browser always uses too much memory after a few queries.

When manually installing the MySQL GUI Tools 5.0, naming the directory name Chinese, or placing it on the desktop to perform MySQL Query Browser, this problem can occur in the Chinese system: ... MySQL GUI Tools 5.0\xml\mysqlqb_functions.xml (Error

There are not many Chinese and Chinese materials.

Import Export support format is too small.