Chapter 8 Running Queries

Table of Contents

8.1 Running HeatWave Queries

The Workspaces tab in the MySQL HeatWave Console provides a Query Editor for running MySQL and HeatWave queries.

Note

Queries can also be run from a MySQL client. See Section 5.2, “Connecting from a Client”.

To run a query using the Query Editor:

1. Connect to a DB System. For instructions, see Section 5.1, “Connecting from the Console”.

2. Enter a query into the Query Editor.

3. Click Run Query.

   The query results are displayed in tabular format by default. You can select the JSON tab to view results in JSON format.

   For multi-statement queries, only the results of the last query are displayed.

   The Job Information tab provides the Job ID, the number of rows returned, and the query statement that was processed.