MySQL Workbench Export query results to SQL file

Previously used is plsql, because changed the company so changed to MySQL, I use when MySQL free client Tool Workbench, because before useless, so there are a lot of features can not be found.

Here are the features used to record:

1: Export the result set of the query into a. sql file

Altogether three data sets

Top option Query->export ResultSet

The default export format is CSV, select Formart->sql INSERT statements

OK this will export the result set of the query into a SQL file, you can also click Export to complete the above operation

View Files

MySQL Workbench Export query results to SQL file