MySQL Workbench
When an SQL query tab is selected, the most important items on the main menu bar are the and menus.
The menu features the following items:
: Executes all statements in the SQL Query area, or only the selected statements.
: Executes all statements in the SQL Query area, or only the selected statements, and displays it in plain text like the standard MySQL command line console.
: Executes the current SQL statement.
: Executes all statements in the SQL Query area, or only the selected statements, and displays it in plain text like the MySQL command line console does vertically (\G).
: Describes the current statement by using the MySQL EXPLAIN statement.
: Visually describes the current statement, based on EXPLAIN information provided by MySQL Server 5.6 and above. MySQL Workbench parses the EXPLAIN (JSON) output from MySQL server 5.6+, and outputs a visual representation.
For additional information about Visual Explain, see Section 7.4, “Visual Explain Plan” and Section 7.5, “Tutorial: Using Explain to Improve Query Performance”.
: Stops executing the currently running script.
: If enabled, MySQL Workbench stops executing the a query if errors are found. It can be enabled/disabled from this menu.
: By default, the number of returned rows (LIMIT) is 1000. Values defined here affects subsequent statements. The number ranges from 10 to 50000, and "Don't Limit".
: Provides data to the Query Stats result set view, which includes statement specific information about Timing, Rows processed, Temporary tables, Joins per type, Sorting, and Index usage.
: Provides data to the Form Editor and Field Types result set views.
: Reconnects to the MySQL server.
: Creates a duplicate of the current SQL Editor tab.
: Enable to auto-commit transactions.
: Commits a database transaction.
: Rolls back a database transaction.
: Commits any changes you have made to the server.
: Discards any changes you have made.
: Exports result sets to a file. Selecting this option displays the Export Query Results to File dialog. The dialog enables 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 to export the data.
The menu provides the submenu. The submenu includes the following menu items:
: Reformats the query selected in the query tab and lays it out in nicely indented fashion.
: Converts keywords to uppercase in the currently selected query in the query tab.
: Converts keywords to lowercase in the currently selected query in the query tab.
: Comments the lines currently selected in the query tab. If the lines are already commented, this operation removes the comments.
: Triggers the auto-completion wizard. This is enabled (and triggered) by default, and can be disabled with , , Automatically Start Code Completion. Auto-completion will list functions, keywords, schema names, table names and column names.