It is possible to edit data in real time using the Live
Editing tabsheets. The live editor is the default view type,
so it will be displayed after running a
SELECT query or by right-clicking a table
in the Schema Viewer and choosing Edit Data
The top part of the result set may be resized to reveal the
SELECT query that it originated from. This
query can be altered to show only columns you want, which
might mean adding a
In addition to the controls offered by the Results tabsheet, the Live Editor tab features some additional controls. These controls are highlighted in the following screenshot.
These additional controls enable you to make changes other than simple edits, like inserting/removing rows and exporting the data.
From left to right, the additional controls are:
Edit current row: Enters edit mode for the currently selected row. Double-clicking a cell has the same effect.
It is possible to enter a function, or other expression,
into a field. Use the prefix
prevent MySQL Workbench from escaping quotation marks. For
example, for the expression
md5('fred'), MySQL Workbench normally
would generate the code
md5(\'fred\'). To prevent this, enter
the expression as
to ensure that the quoting is not escaped.
Insert new row: Inserts a new row and enables you to enter data. Your changes will not be reflected on the live server until you click Apply changes to data.
Delete selected rows: Removes the selected rows. Your changes will not be reflected on the live server until you click Apply changes to data.
Export recordset to an external file: Exports the result set as a file to a defined location. The same as choosing Query, Export Results... from the main menu. Data may be exported as several formats, including CSV, CSV (; separated), HTML, JSON, SQL, and XML.
Import records from an external
file: Imports data from a
CSV file. Data is separated by a comma,
and not the alternative CSV (;
separated) MySQL Workbench export option.
This feature was added in MySQL Workbench 5.2.45.
See also Section 184.108.40.206.8, “The Inserts Tab”.