Export steps of MySQL Workbench query results

This article mainly introduces the MySQL Workbench query results export steps, the contents of the articles are carefully selected and edited by the author, with a certain pertinence, for everyone's reference significance is still relatively great, the following with the author to understand the MySQL Workbench query results export steps.

Steps:

1. Run the query

Click "Export" on the "Results Grid" menu bar.

The screenshot is as follows:

Note: MySQL Workbench limits the result set to 1000 rows by default. If you do not want your result set to be limited to this number (or any other number that has been specified), be sure to remove this limit.

You can change this setting by clicking the Limit to 1000 rows drop-down menu and selecting Don't Limit.

file format

You can choose the file format in which to save the file. The following formats are supported at the time of writing:

1 、 CSV

2. CSV (; separated)

3 、 HTML

4 、 JSON

5 、 SQL INSERT statements

6 、 Excel Spreadsheet

7 、 XML

8. XML (MySQL format)

9 、 Tab separated

Query menu

You can also start the export through the MySQL Workbench Query query menu:

The query menu also provides a "Export Results …" (export results) option.

You can also use SELECT... INTO OUTFILE exports the query results from the query. This will export the file immediately when the query runs.

After reading the above MySQL Workbench query results export steps, many readers must have some understanding, if you need to get more industry knowledge and information, you can continue to follow our industry information column.