In this topic, you will learn, how to view Query Results.
- The “select* from” query that was typed in New Worksheet 7 retrieved data from the database in 54.27 milliseconds.
Note: Since one query is typed in the New Worksheet 7, only Query 1 is displayed in the Results section.
- Click the drop-down list against the rows count to change the number of rows count as required.
Note: By default, the results section can display 1,000 rows on Page1.
- If the number of rows count displays more than 1,000 rows, then consecutively results appear on more than one page to accommodate all the records. You can click the Incremental/Decremental buttons (
,
,
,
) displayed beside the page number to view the required page.
- Another unique feature of DB explorer is that it provisions you to simultaneously run all the queries available in the New Worksheet at once.
- Click the checkbox beside “All Queries” text to run all the queries.
Note: It is mandatory to specify a semicolon at the end of each query while running all queries at one go.
- By default, the Query 2 results are displayed in the Results section. (Hint: Since two queries are available in New Worksheet 7)
- Click the Query drop-down list icon to select Query 1.
- As soon as the Query 1 option is selected, the results of the selected query are displayed in the Results section.
- Click the SQL text option highlighted with an underline (
) beside Query 1 drop-down list under the Results section enables you to edit the selected query (Query 1) in detail.
- A SQL TEXT pop-up window appears on the screen displays Query 1 text.
Note: The significance of this SQL TEXT pop-up helps you to distinguish between all queries available on the New Worksheet. It only displays the query in the pop-up based on the Query selected from the Query drop-down list.
- Click the
. icon to maximize the SQL TEXT pop-up window for an enlarged view.
- Click the
icon to switch back to the original view.
- Click the
icon to close the SQL TEXT pop-up window.