How to export an SQL result to a file

If needed, see how to write SQL query.

  1. You can increase the number of visible rows in the table by entering a number of lines in the Page size text edit. The refresh the view by using the blue Refresh records icon.
  2. select one row, then Ctrl+A to select automatically all the rows of the current table view
  3. right-click on the highlighted records and select Copy Row Values or Copy Row Values (with Headers)
  4. go to your favorite text editor and paste the copied rows