Competition between four common MySQL client tools

This article mainly introduces the comparison of four common tools in MySQL client tools. We all know that MySQL databases are databases that we often learn and practice. Of course, they are also used in our work, some companies use Oracle databases. I think it is too inconvenient to use oracle when doing my own things.

So I found MySQL and considered sqlserver at that time, and thought it was still not as small as MySQL). Since then, I began to contact the following MySQL client tools.

I have contacted a total of four MySQL client tools, including MySQLfront, sqlyog, MySQLbrowser, and EMS MySQL manager. MySQLbrowser was one of my earliest MySQL client tools a year ago ), mySQL was used on a dating website, and the MySQLbrowser was found,

MySQLbrowser has the advantages of being simple and simple. It can be used immediately after installation. The layout is also very simple and its functions are simple and easy to use, especially those who are just learning MySQL can try it.

Next I will use EMS. EMS is another extreme, powerful, and very powerful. Any attribute of tables and fields can be modified at will, so it is powerful and will inevitably bring complexity to use, it can be said that it is not used to its layout at the beginning. It has one of my favorite advantages: shortcut keys, which have many shortcut keys, which are quite different from MySQLbrowser.

The third MySQL client tool I encountered was MySQLfront. It gave me the feeling that the function and ease of use are between MySQLbrowser and EMS. It has many disadvantages. It is better to say that some attributes of the table cannot be modified, and the attributes of some fields.

The fourth is sqlyog. This tool gives me the feeling that it is between MySQLbrowser and MySQLfront, and the overall feeling is not as powerful as MySQLfront.

Through some of my understandings, I think their ranking is 1 MySQLbrowser, 2 sqlyog, 3 MySQLfront, and 4ems. This ranking is based on whether the function is powerful or not. EMS is the most powerful, so I have been using it for a long time. I also recommend that you use EMS MySQL manager. EMS has two versions, lite version is free), professional Edition), I have been using the lite version, programmers, lite version is enough.

Attachment: EMS MySQL Manager Lite 4.0.5.1 download

Recently, phpMyAdmin graphical management tools are also good. phpMyAdmin is written in PHP and can be used to control and operate MySQL over the Internet. PhpMyAdmin can be used to operate databases, such as creating, copying, and deleting data.

Sqlyog can be used as a client software comparable to phpmyadmin. Its operation interface is similar to that of Microsoft SQL server. You can try it. EMS is too powerful. I personally don't think it is necessary to use it, now it is uninstalled.

Download:

SQLYOG v8.14 Chinese Green Edition http://download.csdn.net/source/2074418

The above content is a comparative description of the four MySQL client tools, hoping to help you in this regard.

Original article title: Comparison of four MySQL client tools

Connection: http://www.cnblogs.com/qiantuwuliang/archive/2009/06/28/1512482.html