Differences

This shows you the differences between two versions of the page.

--- how_to:exportsqlresult [2010/02/03 11:25]
132.168.74.230 créée
+++ how_to:exportsqlresult [2010/02/03 11:35] (current)
132.168.74.230
@@ Line 1: / Line 1: @@
-====== How to export SQL result ======
+====== How to export an SQL result to a file ======
-If needed, see [[how_to:writesqlqueries|how to write SQL query]].
+If needed, see [[how_to:writesqlqueries|how to write SQL query]].\\
+  - 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.
+  - select one row, then ''Ctrl+A'' to select automatically all the rows of the current table view
+  - right-click on the highlighted records and select ''Copy Row Values'' or ''Copy Row Values (with Headers)''
+  - go to your favorite text editor and paste the copied rows

hEIDI