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 |