Tabbed Query Mode

Starting from version 2.0 goat has implemented a handy new feature called Tabbed Query Mode. This allows users to execute multiple queries and view the results side by side. To view it in action, simply type in the queries you want to be seen, separated by a semi-colon ';' and select Database->Execute Tabbed Query. This will cause the results of both the queries to be shown side by side as shown below :

 

 

As shown in the above image, the result of each query is displayed in a separate tab. This is very handy in looking at data of different tables at the same time. To look at the query which generated the tab, hover your mouse over the tab, and the tooltip will show the sql that generated the result.

To refresh the query, right click on the tab and select the "Refresh" menu item. To close the tab, click the "Close" menu item.