After you perform an action on a database, you can export
the results to a file on the file system. Several file formats are
supported, including *.html and *.csv, so that you can view the results
in external tools such as spreadsheets. This method can be useful
if you want to more easily share results information with team members
who do not have the workbench installed.
Before you begin
Run a routine or an SQL query.
Procedure
To export results from the SQL Results view:
- Right-click anywhere in the Results tab,
and select or If you
do not see the Results tab, your
database action did not return any results.
- Select a file folder in which to save the result set, enter
a file name and file type, and specify export options. If
you do not specify a file location, the file is saved to the <installation>\eclipse directory.
- Click Finish.
Results
The result set is exported to the file that you specified.
You can open the file from the file system using the appropriate external
program.