This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
how_to:writesqlqueries [2010/02/03 11:02] 132.168.74.230 |
how_to:writesqlqueries [2010/02/03 11:36] (current) 132.168.74.230 |
||
|---|---|---|---|
| Line 17: | Line 17: | ||
| {{:how_to:sqlquery_choosedb.png|}} | {{:how_to:sqlquery_choosedb.png|}} | ||
| - | When you query is written, | + | When you query is written, you can execute it using the ''Run SQL'' icon: |
| + | |||
| + | {{:how_to:sqlquery_execute1.png|}} | ||
| + | |||
| + | If you have several queries in your file, you can select one to execute, then right-click on it and choose ''Run Selection'': | ||
| + | |||
| + | {{:how_to:sqlquery_execute2.png|}} | ||
| + | |||
| + | If your query executed successfully, the result will display in a table.\\ | ||
| + | If needed, see [[how_to:exportsqlresult|how to export an SQL result to a file]]. | ||
| - | ==== SQL queries sample ==== | ||
| - | FIXME Add an example here FIXME | ||