You can useMySQL Workbenchto 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:
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:
Query The menu also provides an "Export Results..." option.
You can also useSELECT ... INTO OUTFILEto 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!