MySQL Query Browser

     MySQL Query Browser is a cross-platform GUI client program that's intuitive and easy to use. It provides
a graphical interface to the MySQL server for querying and analyzing data. The MySQL Query Browser
provides a Connection dialog that enables a connection to a MySQL server. This section describes how to
use the Connection dialog and the Main Query Browser GUI.


Using the Connection Dialog


MySQL Query Browser presents a Connection dialog when it starts or when the New Instance Connection
… is selected from the File menu. Connecting to a MySQL server can be accomplished either by filling in
the connection dialog box fields with the parameters required to connect to a server or selecting from
among any predefined connection profiles.


Connection Dialog Window:

               To connect to a MySQL server by specifying connection parameters directly, fill in the  appropriate fields beginning with the Username field and click the OK button. To connect using the parameters stored in a connection profile, select the profile from the Connection drop-down list and click the OK button. 




The MySQL Query Browser Window

The main MySQL Query Browser window is divided up into several sections: 


o Query Toolbar - The query toolbar is where queries can be created and executed. It is composed of three navigation buttons (Go Back, Next, Refresh), the query area, two action
buttons (Execute and Stop), and a status indicator.


o Advanced Toolbar - The advanced toolbar contains three sets of buttons: the Transaction Buttons (Start, Commit, Rollback), the query management buttons (Explain, Compare), and the query building buttons (Select, From, Where, and so on.)
• The Advanced Toolbar is only visible when the Show advanced toolbars and Show composer
buttons toolbar options in the Browser Options screen are checked.


o Results Area - All query results are displayed in the result area. Multiple tabs can be active at one time, allowing multiple queries to be worked on. The result area can be split vertically and
horizontally for performing comparisons, and queries in different parts of a split result area can be joined together for master-detail analysis.


o Object Browser - The object browser is part of the sidebar and allows for the management of the databases, bookmarks, and history. Databases and tables can be chosen to query, in addition to the ability to add commonly-used queries to a collection of bookmarks, and browse through previously issued queries in order to use them again.

•  If there are many schemata on your MySQL server, the search field with the magnifying glass icon may be handy for filtering the schemata. Typing in t or T, for example, will set the filter to schemata whose names begin with a t. The filter works in a case-insensitive fashion.

•  Filter schemata can also use the wild card (?) to stand in for any single character and (*) for zero to any number of characters. For example the string *boo?* will find schemata with the names books, coursebooks, and bookings.

o Information Browser - The Information Browser is part of the sidebar and is used to look up built-in functions, and to manage queries that contain parameters. One example of this is when establishing a master-detail pair of queries. The data in the master query is available as parameters to the detail query. Using the View menu, most of these sections can be displayed and hidden by checking and unchecking the elements.