Several graphical interface tools of MySQL

A summary of several mysql graphical interface tools, here are the mysql tools I have used

1. The official MySQL Workbench, the open source version is completely free

MySQL Workbench is an ER/ database modeling tool designed specifically for MySQL. It is the 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. MySQL Workbench is the next generation of visual database design and management tools, it has both open source and commercial versions. The software supports Windows and Linux systems.

MySQL Workbench is a visual database design software released by MySQL AB, its predecessor is FabForce's DBDesigner 4.

MySQL Workbench provides visual design, modeling, and database management functions for database administrators, program developers, and system planners. It includes ER models for creating complex data modeling, forward and reverse database engineering, and can also be used to perform document tasks that are often time-consuming and difficult to change and manage. The MySQL workbench can be used on Windows,Linux and Mac.

Official download address:

Https://dev.mysql.com/downloads/workbench/

2.SQLyog

SQLyog official Chinese Registration Edition is a concise, efficient and powerful graphical MySQL database management tool produced by the industry-famous Webyog company. Using SQLyog allows you to quickly and intuitively maintain remote MySQL databases over the network from anywhere in the world.

1. Compact automatic completion.

2. HTTP/HTTPS and SSH channels.

3. Oriented import toolkit.

4. structured synchronization, you can set task plans, synchronize jobs according to a specific time, and verify the synchronization data.

5. Work manager, scheduled backup, notification service, etc.

6. Visual query Editor

7. Programming based on C++ and MySQL API

8. A convenient and fast tool for database synchronization and database structure synchronization

9. Easy-to-use database and datasheet backup and restore functions

10. Support importing and exporting data in XML, HTML, CSV and other formats

11. Run batch SQL script files directly, with extremely fast speed

twelve。 Automatic completion of intelligent SQL statements

Individuals usually use this tool to make sql queries and export excel format data.

3.Toad for MySQL Freeware, it's free.

Simplify code development, query creation, and database object management.

With Toad for MySQL, you can quickly and easily develop code, create and execute queries, and automatically manage database objects. This free development tool allows you to compare, extract and search objects, record and play keyboard commands, and transfer data between MySQL databases. It shortens the MySQL learning curve and helps you manage projects while making MySQL run more efficiently.

A client tool of mysql, toad itself is a client tool of oracle, and now there is a version specially for mysql, which can manage mysql graphically by calling mysql's API.

Students of oracle and those who have used toad for oracle know how powerful toad is, good syntax hints, code formatting and powerful database management functions.

Personally, I feel that toad for mysql is quite powerful, and the execution speed of a slightly larger sql is faster than that of sqlyog, and sometimes sqlyog gets stuck when executing a larger sql.

Official download address:

Https://www.quest.com/cn-zh/products/toad-for-mysql/

4.Navicat for MySQL

Official introduction of https://www.navicat.com.cn/products/navicat-for-mysql

Navicat for MySQL is a visual operation of Mysql database software, the interface is simple, easy to use. Let's briefly introduce the use of this software.

Navicat is a desktop version of MySQL database management and development tool. Easy to learn, easy to use. Navicat uses a graphical user interface that makes it easier for users to use and manage. Chinese is supported and a free version is available.

Individuals usually use this tool to import txt document data into the database.

There are basically green versions available on the Internet. Choose one that you can use easily to make your work easier. Have a good time!