Search Results
https://dev.mysql.com/doc/refman/8.4/en/entering-queries.html
At this point, it is more important to find out a little about how to issue queries than to jump right in creating tables, loading data into them, and retrieving data from them. This section describes the basic principles of entering queries, using ... Make sure that you are connected to the server, as discussed in the previous ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-workspace-running-queries.html
Running Queries 10 Running Queries The Workspace tab in the MySQL HeatWave Console provides a Query Editor for running MySQL and MySQL HeatWave queries. For multi-statement queries, only the results of the last query are displayed. Results from ...
https://dev.mysql.com/doc/refman/8.4/en/parenthesized-query-expressions.html
parenthesized_query_expression: ( query_expression [order_by_clause] [limit_clause] ) [order_by_clause] [limit_clause] [into_clause] query_expression: query_block [set_op query_block [set_op query_block ...]] [order_by_clause] [limit_clause] ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-export-query-results-csv-json.html
This topic shows the different ways to export query results as a CSV file with JSON syntax. INTO OUTFILE WITH PARAMETERS 'file_URI_JSON "file": begin-array ("uri": "OCIFS_URI") | ("uri": "PAR_URI") | ("uri": "NATIVE_URI"), [, "dialect": ...
https://dev.mysql.com/doc/refman/8.4/en/controlling-query-plan-evaluation.html
For join queries, the number of possible plans investigated by the MySQL optimizer grows exponentially with the number of tables referenced in a query. However, when larger queries are submitted, the time spent in query optimization may easily ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-export-query-results-parquet-json.html
This topic shows the different ways to export query results to Parquet files. INTO OUTFILE WITH PARAMETERS 'file_URI_JSON "file": begin-array ("uri": "OCIFS_URI") | ("uri": "PAR_URI") | ("uri": "NATIVE_URI"), [, "dialect": begin-object ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-deploying-query-privatelink.html
Once these network components are configured, your applications connect to your DB System through the VPC Endpoint using a Private Hostname that is only visible within the VPC where the Endpoint exists. Figure 6-1 illustrates the different ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-query-prerequisites.html
Ensure that the following requirements are met before offloading queries to MySQL HeatWave: Use a SELECT statement. To check the autocommit setting: mysql> SHOW VARIABLES LIKE 'autocommit'; +---------------+-------+ | Variable_name | Value | ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/main-queries-reference.html
The main queries enable you to retrieve data from the monitored server. When defining queries, the following restrictions apply: The query must be defined within a <![CDATA[]]> container. Do not define queries which take longer to run than the ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-export-query-results-json-json.html
The option to export query results as an ND-JSON file is available as of MySQL 9.3.1. This topic shows the different ways to export query results as an ND-JSON file. INTO OUTFILE WITH PARAMETERS 'file_URI_JSON "file": begin-array ("uri": ...