Search Results
https://dev.mysql.com/doc/refman/8.4/en/query-attributes.html
Examples of the ways query attributes may be used: A web application produces pages that generate database queries, and for each query must track the URL of the page that generated it. The most visible part of an SQL statement is the text of the ...
https://dev.mysql.com/doc/refman/8.4/en/query-log.html
However, further logging of queries to the file does not occur unless the FILE log destination is selected. If the destination is NONE, the server writes no queries even if the general log is enabled. The general query log is a general record of ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-export-query-results-csv-non-json.html
Therefore, instead of having queries compute results by scanning all the rows for a given range of dates, you can run queries against this aggregate table, saving both time and cost. This topic shows the different ways to export query results as a ...
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/refman/8.4/en/log-destinations.html
However, further logging of queries to the file does not occur unless the FILE log destination is selected. This enables the use of queries that select only those log entries that satisfy specific criteria. For example, to select log contents ...
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 ...