- 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
Once you have successfully executed a query you can then view and manipulate the result set within the result area.
You can navigate the result area using the arrow keys, tab key, and PageUp/PageDown keys. The Home and End keys can be used to move to the first and last column within a given row. Your current position within the result set is shown in the bottom-left corner of the application window. The First and Last buttons at the bottom of the result area can be used to move to the first and last rows of the result set.
NULL data will be indicated with a special NULL
icon to differentiate NULL data from empty strings. BLOB fields
will be empty and will have a special BLOB
icon.
When navigating a particularly large result set, you can press the F12 key to maximize the result area. You can also choose the Maximize Tabsheets option of the View menu to maximize the result area. Pressing F12 again will restore the result area to its original size.
To search for a particular value within the result set, click the Search button. To see additional search options, click the Details >> button. The following options are available:
Case Sensitive: The search is performed in a case-sensitive manner. By default, searches are not case-sensitive.Whole Words Only: The search does not allow partial matches. By default, partial matches are allowed (for example,Edmwill matchEdmonton).Search From Top: The search begins with the first row in the result set.Search From Cursor: The search begins from the currently selected row.Search all Text / Columns: The search will involve all columns of the result set.Search Only in Selected Text / Column: The search will only involve the currently selected column(s) of the result set.Search Up: The search will scan the result set, starting at the designated start location and moving upwards.Search Down: The search will scan the result set, starting at the designated start location and moving down.
To perform a search and replace operation on a result set, click
the Replace tab in the search dialog window.
The options for performing a replace operation are the same as for
a search. To replace a single instance of a string, click the
Replace button. To replace all instances of
a string, click the Replace All button.
