8.1.3 Query and Edit Menus
When an SQL Editor tab is selected, the most important items on
the main menu bar are the
SQL Query Menu
menu features the following items:
Executes all statements in the SQL Query area, or only the
: 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
Describes the current statement by using the MySQL EXPLAIN
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 Visual 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".
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.
Provides data to the
to the MySQL server.
Creates a duplicate of the current SQL Editor tab.
to auto-commit transactions.
: Commits a
: Rolls back
a database transaction.
: Commits any
changes you have made to the server.
any changes you have made.
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.
: Exports result
sets to a file. Selecting this option displays the
menu features the
submenu includes the following
: Reformats the
query selected in the query tab and lays it out in nicely
keywords to uppercase in the currently selected query in the
keywords to lowercase in the currently selected query in the
the lines currently selected in the query tab. If the lines
are already commented, this operation removes the comments.
Automatically Start Code
Completion. Auto-completion will list functions,
keywords, schema names, table names and column names.
: Triggers the
auto-completion wizard. This is enabled (and triggered) by
default, and can be disabled with