GUI tools for MySQL

MySQL has a lot of GUI tools, here are a few common tools, for reference only:

1.Navicat for MySQL

1.1. Introduction

Navicat for MySQL is a powerful MySQL database management and development tool. NAVICAT provides professional developers with a powerful and sophisticated set of tools, but it is still easy to learn for new users. With an excellent graphical user interface (GUI), you can quickly and easily create, organize, access, and share information in a safe and easy way. Based on the Windows platform, MySQL is tailor-made to provide a management interface tool similar to MSSQL. Users can fully control the MySQL database and display different management materials, including a multi-functional graphical management of users and access rights management tools to facilitate the transfer of data from one database to another database (Local to remote, remote to remote, remote to Local) for file backup. Navicat supports Unicode, as well as local or remote MySQL server multiple connections, users can browse the database, create and delete databases, edit data, establish or execute SQL queries, manage user rights (security settings), Backup/restore databases, import/Export data (support CSV, TXT, DBF, and XML file types). The new version is compatible with any MySQL 5.0.x server, supports Triggers, and binary varbinary/bit data types.

Its features are very rich and highly recommended:

1.2.Navicat for MySQL main features

-Form view (new)

-Virtual Group (new)

-Auto End Code (new)

-Automatic transfer of scheduled work results email (new)

-Query, view and event auto-completion (new)

-Report can be remitted into various formats, PDF, Excel, HTML, etc. (new)

-Timeout automatically reconnect to SQL Server

-Data and fabric synchronization

-Export the registration file for transfer to another computer

-New query Creator--Create queries for different databases

-Query parameters

-sql Console

-Build View

-ssh Key

-navicat supports all MySQL versions

-ssh and HTTP Tunnels

-Import/Export data

-Report Design and establishment

1.3. Example

1.3.1 Query

With the filtering function, it is very convenient to query:

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M00/49/D7/wKioL1QbyC7hSMWNAAMO2olQe1A648.jpg "title=" aa.png "alt=" Wkiol1qbyc7hsmwnaamo2olqe1a648.jpg "/>

1.3.2 Command Line interface

You can use this feature for work that you like, or that only the command-line interface can accomplish.

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M02/49/D5/wKiom1Qby7rQvDhgAAOqluUO_QA386.jpg "title=" Q.png " alt= "Wkiom1qby7rqvdhgaaoqluuo_qa386.jpg"/>

1.3.3 Query Optimization function

1.3.3.1. Basic information

The tool has a strong advantage in this area, such as listing the basic information of a query statement, such as the number of rows and times affected:

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M02/49/D5/wKiom1QbzGDya52SAANxl4h4rd4812.jpg "title=" 1.png " alt= "Wkiom1qbzgdya52saanxl4h4rd4812.jpg"/>

1.3.3.2 The analysis results of the query optimizer, such as whether to use indexes or not:

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M00/49/D5/wKiom1QbzO2TzLVNAAPgJox879s506.jpg "title=" 2.png " alt= "Wkiom1qbzo2tzlvnaapgjox879s506.jpg"/>

1.3.3.3. Analyze the summary of the statement:

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M01/49/D5/wKiom1QbzYbBpO7DAAU4KJR5v7U832.jpg "title=" 3.png " alt= "Wkiom1qbzybbpo7daau4kjr5v7u832.jpg"/>

1.3.3.4. Look again for the status value for the optimization reference:

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M02/49/D5/wKiom1Qbzimyx5wRAAhD9qyl4Ac585.jpg "title=" 4.png " alt= "Wkiom1qbzimyx5wraahd9qyl4ac585.jpg"/>

There are also very useful features that look forward to discovering and digging.

2.SQLyog

2.1. Introduction

SQLyog is a simple, efficient and powerful graphical MySQL database management tool produced by the industry-renowned Webyog company. With SQLyog, you can quickly and intuitively maintain a remote MySQL database from anywhere in the world through the network.

SQLyog has the following features compared to other similar MySQL database management tools:

1, based on C + + and MYSQLAPI programming;

2. Convenient and fast database synchronization and database structure synchronization tool;

3, easy to use database, data table backup and restore function;

4, support import and export of XML, HTML, CSV and other formats of data;

5, run the batch SQL script file directly, the speed is very fast;

6, the new version is to increase the powerful data migration function

2.2. Basic Features:

Quickly back up and restore data.

Displays the results in grid/text format.

Enable clients to pick and filter data.

Large SQL script files are executed in bulk.

Fast execution of multiple queries and the ability to return recordsets with more than 1000 records per page, which is generated directly in memory.

The program itself is very short and concise! Only 348 KB after compression.

Fully use the MySQL C APIs program interface.

Create or edit data tables in an intuitive tabular interface.

Edit the data in an intuitive tabular interface.

For index management.

Create or delete a database.

Manipulate the database's various permissions: libraries, tables, fields.

Edit field of BLOB type, support Bitmap/gif/jpeg format.

Output data table structure/data is SQL script.

Support input/output data to CSV file.

You can export the database manifest as an HTML file.

Establish a log for all operations.

Personal collection Management action statement.

Syntax highlighting is supported.

You can save a file with a recordset in CSV, HTML, and XML format.

99% of the operation can be done by shortcut keys.

Supports modifications to various advanced properties of the data table.

View the various states, parameters, etc. of the data server.

Support for changing data table types is ISAM, MYISAM, MERGE, HEAP, InnoDB, BDB.

Refreshes the data server, logs, permissions, tables, and so on.

Diagnostic data Sheets-inspection, compression, patching, analysis.

2.3 Special Features

In addition to completing the usual functions of other GUI tools, there is something unique about it.

2.3.1 Table Optimization function

On the Tools menu, click on the "Datasheet Diagnostics" tab and pop up the data table diagnostic bar.

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M01/49/D7/wKioL1Qb04nx1XXaAAEg5xHYDs4828.jpg "title=" 5.png " alt= "Wkiol1qb04nx1xxaaaeg5xhyds4828.jpg"/>

With the table selected, first click on "Optimize":

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M00/49/D5/wKiom1Qb08uhx0ZEAAFOhW9PLZI469.jpg "title=" 6.png " alt= "Wkiom1qb08uhx0zeaafohw9plzi469.jpg"/>

Click "Check" again:

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M01/49/D5/wKiom1Qb1BKwE037AADO1OUA7VU903.jpg "title=" 7.png " alt= "Wkiom1qb1bkwe037aado1oua7vu903.jpg"/>

And so on, the analysis and table repair function can be done.

2.3.2. Support syntax highlighting and SQL formatting

This is useful for developing and writing SQL, supports syntax highlighting, automatically prompts, and supports direct view of the execution plan. For executed queries, you can see the profile results directly.

3.MySQL Workbench

3.1 Introduction

MySQL Workbench is a er/database modeling tool designed for MySQL. It is a successor to the famous database design tool DBDesigner4. You can use MySQL workbench to design and create new database diagrams, create database documents, and perform complex MySQL migrations.

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M02/49/D7/wKioL1Qb1myiWqmsAAVFxFcHuOc739.jpg "title=" 8.png " alt= "Wkiol1qb1myiwqmsaavfxfchuoc739.jpg"/>

3.2. Monitoring Backup Recovery

can be used to monitor, backup and restore the database, improve the efficiency of administrative personnel maintenance.

3.3 Modeling Data

Workbench's modeled chart is very beautiful, the disadvantage is not strong versatility.

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M00/49/D7/wKioL1Qb2YjR5E_nAAqRNE_lz_8062.jpg "title=" 9.png " alt= "Wkiol1qb2yjr5e_naaqrne_lz_8062.jpg"/>

4. Summary

Each GUI tool has its characteristics, everyone's habits are very different, choose the right tool for their own, can effectively complete the task of the line. Of course, for the optimization, the individual feels that Navicat for MySQL provides a lot of information, is worth using the tool, but for modeling, although some tools also provide this function, but compared to the MySQL Workbench a lot of color loss.

GUI tools for MySQL