Home >Database >Mysql Tutorial >How to export query results from MySQL Workbench? (pictures and text)

How to export query results from MySQL Workbench? (pictures and text)

藏色散人
藏色散人Original
2019-04-03 10:36:379162browse

You can use MySQL Workbench to run a query and then export the results of that query to a file. (Related recommendations: "MySQL Tutorial")

Steps:

1. Run query

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

Screenshot below:

How to export query results from MySQL Workbench? (pictures and text)

Note:MySQL Workbench The result set is limited to 1000 rows by default. If you do not want your result set to be limited to this number (or another 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 are the supported formats 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:

How to export query results from MySQL Workbench? (pictures and text)

Query The menu also provides an "Export Results..." option.

You can also use SELECT ... INTO OUTFILE to export the query results from the query. This will export the file as soon as the query runs.

This article is an introduction to MySQL Workbench exporting query results. I hope it will be helpful to friends in need!

The above is the detailed content of How to export query results from MySQL Workbench? (pictures and text). For more information, please follow other related articles on the PHP Chinese website!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn