MySQL client tool selection, mysql client Tool

MySQL client tool selection, mysql client Tool

Recently, due to system cloudification projects, I learned to use MySQL clusters. To find a handy mysql client, I have repeatedly used multiple tools and screened out a self-satisfied MySQL client. I will share it here.

Let's talk about SQLyog.

Clients tried: Toad for MySQL, MySQL-Front, Navicat for MySQL, and SQLyog.

Official download link:

Toad for MySQL: http://www.toadworld.com/m/freeware/1469/

MySQL-Front: http://www.mysqlfront.de/

Navicat for MySQL: https://www.navicat.com/en/download/navicat-for-mysql

SQLyog: https://www.webyog.com/product/sqlyog

Comparison:

Toad for MySQL

Advantage: free. In the past, oracle can be used to set similar interfaces and shortcut keys for toad for oracle.

Disadvantage: the support for Chinese characters is severely inadequate. The select field as Chinese or where condition cannot be used to match Chinese strings, and garbled characters are directly involved. Converting character sets in SQL using convert and other methods cannot be solved, so you have to discard the tool.

MySQL-Front

It is free and can be used as a whole, that is, it has fewer functions and is relatively simple compared with paid software.

Navicat for MySQL

Currently, fees are charged. I used to use commercial software such as plsql developer and toad for oracle. navicat is still relatively simple and uncomfortable to use.

SQLyog

Charged. Compared with navicat, SQLyog is selected.

For example, there are many highlights:

In short, it is easy to use, and there are many user-friendly places.

Finally add a download link, you know: http://pan.baidu.com/s/1dF9iPFF