All query results are displayed in the result area. Within the result area you can use multiple tabs, and individual result areas can be split either vertically or horizontally. New tabs can be created either by choosing the Execute in new Tab option on the query bar, or by clicking the New Tab button at the top of the result area. In addition, you can also right click on the current result area and choose the Add new Tabsheet (Ctrl+T) option.
Individual tabs are closed by either right clicking within the
result area and choosing the Remove Tab option,
or by clicking the X
icon on the tab you wish
to close.
To split a result area, right click on it and choose either the Split Tab vertically or the Split Tab horizontally option. After splitting the result area you can then choose one half of the result area and view result sets within it. You can remove sections of the result area by right clicking on the section you wish to remove and clicking Remove Resultset.
When navigating a particularly large result set, you can press the F12 key to maximize the result area or, alternately, you can choose the Maximize Tabsheets option of the View menu. Under Windows, pressing F12 again will restore the result area to its original size. Under Linux, to revert to the normal view choose the Normal View menu option under the View menu.
The result sets of some queries do not display well in the
Results Area
; SHOW CREATE TABLE
, for example. For a
better view of the results of such queries, right click the row
you wish to view and choose the tblname
View Field in Popup
Editor
option from the pop-up menu.
The result area can be used to review and edit the results of a query, with editing permitted as long as the query is based on a single table and there is sufficient key information to uniquely identify rows. To edit the contents of the result area you must enable edit mode through the use of the Edit button at the bottom of the result area. Any edits you make are not immediately applied, but instead you need to click the Apply Changes button next to the Edit button. Clicking the Discard Changes button throws away any changes you have made to the data.