MySQL Workbench Manual  /  ...  /  Result Data Export and Import

6.5.3 Result Data Export and Import

Export or Import data directly from or into the result set.

Export a Result Set

A result set in the visual SQL editor can be exported to common file formats including CSV, JSON, HTML, and XML.

Note

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”.

Figure 6.27 Exporting a Result Set

Exporting a Result Set

Import into a Result Set

Records from a CSV file can be imported into the result set of the visual SQL editor.

Note

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.

Note

Alternatively, use Section 6.5, “Data Export and Import” to export larger sets of data, such as entire tables and databases.


User Comments
Sign Up Login You must be logged in to post a comment.