Query Analyzer is a graphical tool for MySQL database programming that enables complex queries to be written and results viewed in real-time through a rich user interface.
Function tool tips are also provided, which appear for each function you type. This is especially useful for those who may not remember all of the MySQL functions, as the tool tips remind you of parameter types and provide an explanation of what each function does.
A tree of all objects in the current server is available, including all databases and tables, along with a list of functions under each category. Objects can be dragged from the tree and placed into your window with ease.
Myquery Analyzer also offers syntax color editing, which colors the syntax of each MySQL reserved word. This allows you to catch errors before running your queries, saving you time and hassle. Multiple statement queries are also possible, allowing you to type as many queries as you want and view the results of each in its own grid.
One of the most impressive features of Myquery Analyzer is its ability to handle locking problems. Accessing a locked resource can cause the program to hang, which can be frustrating during testing phases. However, Myquery Analyzer simply puts you in a waiting state while you continue working with other windows.
Finally, the software allows for multiple documents to be opened and connected to any number of servers you want. This feature is intuitive and makes managing multiple databases effortless. Overall, Myquery Analyzer is an incredibly useful tool for anyone who manages MySQL databases on a frequent basis.
Version 1.0: N/A