Search Results
https://dev.mysql.com/doc/refman/8.4/en/rewriter-query-rewrite-plugin-usage.html
To enable or disable the plugin, enable or disable the rewriter_enabled system variable. By default, the Rewriter plugin is enabled when you install it (see Section 7.6.4.1, “Installing or Uninstalling the Rewriter Query Rewrite Plugin”). To ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/formatting-queries-reference.html
It is possible to format the query result with wiki markup. This enables you to display information from the query directly in the event generated by the advisor. This example lists the user name and host for all accounts without a defined password. See Section 31.1.7, “Wiki Format” for more information on the supported wiki ...
https://dev.mysql.com/doc/refman/8.4/en/query-attribute-components.html
A component service provides access to query attributes (see Section 11.6, “Query Attributes”). The query_attributes component uses this service to provide access to query attributes within SQL statements. Purpose: Implements the ...
https://dev.mysql.com/doc/refman/8.4/en/rewriter-query-rewrite-plugin.html
This plugin also supports a privilege (SKIP_QUERY_REWRITE) that protects a given user's queries from being rewritten. MySQL supports query rewrite plugins that can examine and possibly modify SQL statements received by the server before the server ...
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/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 ...