Export or Import data directly from or into the result set.
A result set in the visual SQL editor can be exported to common file formats including CSV, JSON, HTML, and XML.
This wizard only exports/imports data from a result set. For an overview of the data export and import options in MySQL Workbench, see Section 6.5, “Data Export and Import”.
Records from a CSV file can be imported into the result set of the visual SQL editor.
The result set must have a unique row identifier (such as a Primary Key or NOT NULL unique index) as otherwise values can not be imported because the result set will be read-only.
Alternatively, use Section 6.5, “Data Export and Import” to export larger sets of data, such as entire tables and databases.