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

This article introduces you how to analyze MySQL database through SQLyog, the content is very detailed, interested friends can refer to it, I hope it can help you.

Database, table and column tree

As soon as the program started, it started asking for my password to log on to MySOL server. I just need to enter my server name, user id and login password. All other settings are correct defaults. Then (after I started something else, restarted a few times, and slept for a while), I ran the program again, just typing in my login password again. The program doesn't have the option to save passwords, which you can consider a bug in the program, or a security feature of the program.

Once you log in, the interface is remarkable. 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 representing the database granted to you, you will see a series of nodes representing tables. After clicking on the table node, you can see a series of nodes showing the field names and another set of nodes representing the index.

The index interface is definitely a nice touch, so you can CRUD index and keyword queries. This is an improvement over front-end databases such as Microsoft Access. This part of the program is mature in design considering that MySOL is just beginning to provide support for primary and foreign keyword relationships. On the lower right panel, there are four tabs: Result, Message, Object, and History.

What's the downside?

I tried to find a flaw in the program, but only found one. If you run the program's.exe file under Win32 Dependency Walker, you'll notice that it references the file COMDLG32.dll, which in turn references AppHelp. In fact, CommDlg calls AppHelp, which is a waste of resources when AppHelp doesn't request functions.

Too simple?

On the SQLyog FAQ, there is a view that the software does not need to be formally archived. Of course, FAQs (frequently asked questions) are an archive in themselves. SQLyog's interface is intuitive. I suggest you print a copy of the MySOL documentation (including SQL special syntax extensions). That's what I did, and it only used a half inch loose-leaf cover.

Last step?

The FAQ also conjures up a callus-inducing yet correct Occams Razor rule--that all complexity is unnecessary. The reason I'm "selling" this tool around is because it gives us a simple, graphical interface to manage the many databases on MySOL servers. It's extremely fast, and its copies are small (enough to fit on a floppy disk).

SQLyog claims to be a query analyzer, but 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 get a taste of its other features.

About how to analyze MySQL database through SQLyog to share here, I hope the above content can be of some help to everyone, you can learn more knowledge. If you think the article is good, you can share it so that more people can see it.

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.