如何用SQLyog来分析MySQL数据库（How to analyze MySQL database with SQLyog）.doc

如何用SQLyog来分析MySQL数据库（How to analyze MySQL database with SQLyog） Analyze MySQL database with SQLyog: The download, installation, and use of SOLyog is simple. I went to the relevant website to download it, and its only 384K bytes. It installs two Files (an executable, exe and a dynamic link library file. DLL) into C: \ Program Files \ SQLyog path. Then run the executable. There is no need to access the site after installation, and I visited the site to get a message that its domain name was not configured, registered, or under construction. I dont know whether the problem is temporary or always. The software is free and has no logo ads (banner ads), so it may be a specific, yet unfinalized, business model. It might still end up being a negative charge. Database, table (table) and column tree (column tree) As soon as the program started, I started asking my login to the MySOL servers password. I only need to enter my server name, user id, and login password. All other Settings are the correct default values. Then (when I started other transactions, rebooted, and slept for a while), I rerun the program, only to enter my login password again. The program does not have the option to save the password, which you can think of as a bug in the program, or a secret feature of the program. Once youve logged in, the interface is worth noting. All the databases on the MySOL server are displayed on a tree control. You can only access the database that you authorized when you logged in. If you click on the tree structure of the database that the delegate authorized to give you, you can see a series of nodes representing the table. After the table node is opened, you can see a series of nodes that display the name of the field and the collection of nodes representing the index. The index interface is definitely a good thing, so you can CRUD query indexes and keywords. This is an improvement over front-end databases such as Microsoft Access. If you consider that MySOL has just starte