Navicat for MySQL and MySQL GUI tools function comparison

Source: Internet
Author: User
Tags comparison mysql query mysql database mysql gui mysql gui tools

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.

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.