- 9 Using The MySQL Query Browser
- 9.1 Entering and Editing Queries Manually
- 9.2 Building Queries
- 9.3 Creating Views
- 9.4 Navigating Result Sets Within the Result Area
- 9.5 Exporting Result Sets
- 9.6 Handling BLOB and TEXT Columns
- 9.7 Editing Result Sets Within the Result Area
- 9.8 Comparing Result Sets
- 9.9 Managing Stored Procedures and Functions with MySQL Query Browser
- 9.10 Editing Queries From a Development Tool
- 9.11 Using the Regex Text Importer Tool
The query browser is most commonly used for executing queries and analyzing their results. The most direct way to create a query is to type it directly into the query area. As you type in your query, the SQL syntax portions of the query (SELECT, FROM, WHERE, and so on) are highlighted in blue.
As you enter your query, the query area will expand from an initial three lines in height to a maximum ten lines in height. For additional space, you can press the F11 key to maximize the query area. You can also choose the Maximize Query Area of the View menu to maximize the query area. When the query is maximized, line numbers are displayed for the query, and the query area can be resized by clicking and dragging the line that divides the query area from the result area. To restore the query area, press the F11 key again.
Once you have entered a query, click on the Execute button and your query results are displayed in the result area. You can also press Ctrl+ Enter to execute the query. If there is an error in your query, an error area appears at the bottom of the result area and displays the relevant error message and error number.
In addition to loading the query results into the current active result area, you can also create a new result area for the results of your query or split your current result area and load results into the new section.
To execute the query and load the results into a new result area click the down-arrow below the Execute button and choose the Execute in new Tab option or press Ctrl+Shift+Enter .
To split the active result area and display the query results click the down-arrow below the Execute button and choose the Split Tab and Execute option or press Ctrl+Alt+Enter .
You must set a default database before you can query specific tables (though you can still perform queries that are not database-specific). You can set the default database at the connection screen, or by right-clicking on a database in the database browser and choosing Make Default Schema, or by choosing the Change Default Schema option from the File menu.
