|
|
|
|
|
|
|
|
|
|
- Overview
- Query: ribbon options
HFSQL Control Center: Creating and executing a query
The HFSQL Control Center allows you to create a query based on the data files of the database currently displayed in the Control Center. To create a query: - In the ribbon, go to the "SQL query" group, expand "New query" and select "Blank query".
- A new tab corresponding to the new query is displayed.
- If necessary, select the database on which the query should be made and write the SQL code of the query.
- To execute the query, select "Run" in the ribbon.
Note: The query can also be created using a wizard.. The Query ribbon offers the following options:
The "SQL query" group includes the following options: - New query: Allows you to create a new query, either directly by entering the SQL code, or via the wizard..
- Open a query: Opens a previously saved query or one from the history..
- Save: Saves the current query.
- Close query: Closes the currently displayed query.
The "Execution" group includes the following options: - Execute: Executes the query displayed in the current tab.
- Suggest keys: Suggest keys to optimize query performance.
- Display EXPLAIN: Displays the query EXPLAIN graphically or in XML form.
The "Transactions" group includes the following options: - Start transaction: starts a transaction before executing the request. Once the transaction has started, you can validate it at any time by selecting "Validate transaction".
- Roll back a transaction: if necessary, roll back the current transaction..
The "Other actions" group includes the following options: - Query history: provides a list of all queries made from the HFSQL Control Center, whether executed or failed..
- List of SQL keywords: provides a list of SQL keywords that can be used in SQL queries.
This page is also available for…
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|