Search Results
https://dev.mysql.com/doc/c-api/8.4/en/query-results.html
In addition to the result set returned by a query, you can also get the following information: mysql_affected_rows() returns the number of rows affected by the last query when doing an INSERT, UPDATE, or DELETE. With mysql_store_result(), ...
https://dev.mysql.com/doc/internals/en/optimizer-union-queries.html
Therefore, for this query: SELECT * FROM Table1 WHERE column1 = 'x' UNION ALL SELECT * FROM TABLE1 WHERE column2 = 'y' if both column1 and column2 are indexed, then each SELECT is done using an indexed search, and the result sets are merged. Notice ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-export-query-results.html
As of MySQL 9.1.1-u1, you can export your query results on DB System tables and external Lakehouse tables to Object Storage. This feature is available for MySQL HeatWave on OCI and MySQL HeatWave on AWS. The capability to convert the output into ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-queries.html
By contrast, post-filtering is performed by individual users through the use of queries with appropriate WHERE clauses that restrict what event information to select from the events available after pre-filtering has been applied. Pre-filtering ...
https://dev.mysql.com/doc/refman/8.4/en/rewriter-query-rewrite-plugin-installation.html
Note If installed, the Rewriter plugin involves some overhead even when disabled. To avoid this overhead, do not install the plugin unless you plan to use it. To install or uninstall the Rewriter query rewrite plugin, choose the appropriate script ...
https://dev.mysql.com/doc/connectors/en/connector-odbc-usagenotes-functionality-query-timeout.html
For more information on how to set the query timeout on Microsoft Windows when executing queries through an ODBC connection, read the Microsoft knowledgebase document at ...
https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-usagenotes-functionality-query-timeout.html
For more information on how to set the query timeout on Microsoft Windows when executing queries through an ODBC connection, read the Microsoft knowledgebase document at ...
https://dev.mysql.com/doc/ndbapi/en/mccj-clusterj-query.html
Provides interfaces for building queries for ClusterJ. ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/custom-queries-reference.html
This section describes the precondition and main queries used to create custom data collections.
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-export-query-results-csv.html
You can export the query results to a RFC-4180 compatible CSV file.