Shulou(Shulou.com)05/31 Report--

This article is about how to use SQLyog to analyze MySQL database, the editor thinks it is very practical, so I share it with you to learn. I hope you can get something after reading this article.

Use SQLyog to analyze the MySQL database:

SOLyog is easy to install, install, and use. I went to the relevant website to download, it is only 384K bytes. It installs two files (an executable file .exe and a dynamic link library file .dll) to the C:Program FilesSQLyog path. Then run the executable file.

There is no need to visit the site after installation. I visited the site and got a message that its domain name was not set up (configured), registered, or under construction. I don't know whether the problem is temporary or always. The software is free and has no logo advertising (banner ads), so it may be a specific business model that has not yet been finalized. You may have to pay for it in the end.

, table (table) and column tree (column tree)

As soon as the program starts, it starts asking for my password to log in to the MySOL server. I just need to enter my server name, user id and login password. All other settings are the correct default values. Then (after I started other transactions, restarted several times, and slept for a while), I rerun the program, and all I had to do was enter my login password again. The program does not have the option to save the password, you can think of this as a bug of the program, or the confidentiality feature of the program.

Once you log in, the interface is noteworthy. All databases on the MySOL server are displayed on a tree control. You can only access the database you authorized when you logged in. If you click on the tree structure that represents the database authorized to you, you can see a series of nodes that represent the table. After clicking on the table node, you can see a series of nodes that display the field name and another collection of nodes that represent the index.

The indexing interface is definitely a good thing, so you can CRUD indexes and keywords. This is an improvement over front-end databases such as Microsoft Access. Considering that MySOL is just beginning to provide support for primary and foreign keyword relationships, the design of this part of the program is very mature. On the lower right panel, there are four tabs, namely, Result, Message, Object, and History.

What are the shortcomings?

I tried to find the shortcomings of the program, but only found one. If you run the program's .exe file under Win32 Dependency Walker, you will find that it references the COMDLG32.dll file, while COMDLG32.dll takes turns referencing AppHelp. In fact, CommDlg calls AppHelp, and when AppHelp does not request a function, CommDlg is simply wasting resources.

Too simple?

On SQLyog FAQ, there is a view that there is no need for formal filing of the software. Of course, FAQ (frequently asked questions) is itself an archive. The interface of SQLyog is very intuitive. I suggest you print a MySOL document (including SQL special syntax extensions). That's what I did. It only used a half-inch loose-leaf cover.

Last step?

FAQ is also reminiscent of a callous but correct Occams Razor rule-everything that is more complex than necessary is unnecessary. I "promote" this tool everywhere because it provides us with a simple, graphical interface that can manage many databases on MySOL servers. It is extremely fast, and its copy is very small (can be placed on a floppy disk).

SQLyog claims to be a query analyzer, but in fact it does much more than that. If you are using MySOL, you can download SQLyog from its website (you need to register your name and email address) and experience its other features.

The above is how to use SQLyog to analyze MySQL database. The editor believes that there are some knowledge points that we may see or use in our daily work. I hope you can learn more from this article. For more details, please follow the industry information channel.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.