Below the query bar is the Advanced Toolbar. The Advanced Toolbar contains a set of buttons for transaction control, query management, and query building.

Figure 8.4. The Advanced Toolbar

The left panel of the advanced toolbar contains the transaction control buttons. From left to right, the buttons allow you to start, commit, and roll back a transaction. As when using the command-line client, you can only use transactions with table handlers that support them (InnoDB for example). For more information on transactions, see The InnoDB Transaction Model and Locking.

The center panel provides buttons for query management. The Explain button can be used to get the EXPLAIN output for the current query from the MySQL server. When you use this feature, the results are shown below the result set window. To remove this window right click anywhere in the window and choose the Remove Resultset option.

The Compare button allows you to compare the results of two queries.

The next panel contains the query building buttons. You can use these buttons to build a query visually by clicking on the tables and columns that you wish to involve in your query, using specialized mouse pointers to indicate which part of the query the different fields and tables occupy.

The right panel contains the Create View button. More information on the Create View button can be found in the Creating Views section.