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 .
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 WHERE clause.
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.
NoteIt is possible to enter a function, or other expression, into a field. Use the prefix
\functo prevent MySQL Workbench from escaping quotation marks. For example, for the expressionmd5('fred'), MySQL Workbench normally would generate the codemd5(\'fred\'). To prevent this, enter the expression as\func md5('fred')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 .
Delete selected rows: Removes the selected rows. Your changes will not be reflected on the live server until you click .
Export recordset to an external file: Exports the result set as a file to a defined location. The same as choosing , 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
CSVfile. Data is separated by a comma, and not the alternative MySQL Workbench export option.This feature was added in MySQL Workbench 5.2.45.
See also Section 7.7.1.3.8, “The Inserts Tab”.
User Comments
Add your own comment.