How to use SQLyog to analyze MySQL database _ MySQL

Explain in detail how to use SQLyog to analyze MySQL databases and use SQLyog to analyze MySQL databases:

SOLyog is easy to download, install, and use. I went to the relevant website to download it. it is only KB in size. Install two files (one executable file .exe and one dynamic link library file. dll) to the C: Program FilesSQLyog path. Then run the executable file.

There is no need to access the website after installation. when I access the website, I get a message saying that its domain name is not configured (configured), registered, or under construction. I don't know whether the problem is temporary or not. The software is free and has no banner ads, so it may be a specific business model that has not yet finalized. In the end, you may still be charged.

Database, table, and column tree)

This program starts to ask me the password to log on to the MySOL server as soon as it is started. I only need to enter my server name, user ID, and login password. All other settings are the correct default values. Then (when I start other transactions, restart several times, and sleep for a while), I re-run the program, then I only need to 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 of the program.

Once you log on, the interface is worth noting. All databases on the MySOL server are displayed on a tree control. You can only access the database you authorize when you log on. If you click on the tree structure that represents the database authorized to you, you can see a series of nodes representing the table. After clicking open table nodes, you can see a series of nodes that display field names and a set of nodes that represent indexes.

The index interface is definitely a good thing, so you can CRUD to query indexes and keywords. This is an improvement for front-end databases such as Microsoft Access. If MySOL has just begun to provide support for the primary (primary) and non-correlated (foreign) keywords, the design of this part of the program is very mature. In the lower right pane, there are four tabs, namely Result, Message, Object, and History ).

What are the disadvantages?

I tried to find out the disadvantages of the program, but only found one. If you run the .exe file of the program under Win32 Dependency walker, you will find that it references the COMDLG32.dll file, and COMDLG32.dll references AppHelp in turn. In fact, CommDlg calls AppHelp. when AppHelp does not request a function, CommDlg is a waste of resources.

Too simple?

On the SQLyog FAQ, there is a point of view that the software does not have to be formally archived. Of course, FAQ (FAQ) is an archive. The SQLyog interface is very intuitive. I suggest you print out a MySOL document (including SQL special syntax extensions ). That's what I did. it only uses a half-inch Living page cover.

Last step?

The FAQ also reminds people of the Occam's Razor principle, which makes them easy to understand but is the correct one-everything beyond the necessary complexity is unnecessary. The reason why I promote this tool everywhere is that it provides us with a simple, graphical interface that can manage many databases on the MySOL server. It is extremely fast, and its copy is very small (it can be placed on a floppy disk ).

SQLyog claims to be a query Analyzer. In fact, it has far more functions than this. If you are using MySOL, you can download SQLyog from its website (you need to register your name and email address), and then feel its other functions.