When a SQL Editor tab is selected the most important item on the main menu bar is Query. The Query item features the following menu items:
Execute (All or Selection) - causes all statements in the SQL Statements area to be executed, or only the statements selected.
Execute Current Statement - causes the current SQL statement to be executed.
Explain (All or Selection) - describes all statements, or the selected statement.
Explain Current Statement - describes the current statement.
Stop - stop execution of the currently running script.
Reconnect to Server - reconnect to the MySQL server.
New Tab - Creates a duplicate of the current SQL Editor tab.
Commit Transaction - commits a database transaction.
Rollback Transaction - rolls back a database transaction.
Refresh - synchronizes with the live server and refreshes views such as the live Overview tabsheet.
Commit Result Edits - commits any changes you have made to the server.
Discard Result Edits - discards any changes you have made.
Export Results - This allows you to export result sets to a file. Selecting this option displays the Export Query Results to File dialog. The dialog allows you to select which result set you wish to export, the file format (CSV, HTML, XML) and the name and location of the output file. Then click Export to export the data.
