Step 1
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, in the path C: \ Program Files \ SQLyog. 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 with 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 logo), so it may be a specific business model that has not yet finalized. In the end, you may still be charged.
Grok the yog
What is yog? If you are a followers of Heinlein, refer to his work "Stranger in a Strange Land"), you must be familiar with the new word "grok, the general idea is "a complete, almost empathy understanding ". "Yog" is an Hindi Word, and its meaning can be roughly the same as that of "grok. Therefore, if you are not a followers of Heinleinian, the contents of grok SOLyog from now on are only 600 pages.
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) and non-related foreign keyword relationships, 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 Frequently Asked Questions) is an archive. The SQLyog interface is very intuitive. I suggest you print out a MySOL document including SQL special syntax extension ). 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 and can be placed on a floppy disk ).
SQLyog claims to be a query analyzer. In fact, it has far more functions than this. I really want to fully introduce all its functions and features, but this is too much. If you use MySOL, I suggest you download SQLyog on its website and register your name and email address), then install and feel its functions.
(