Search Results
https://dev.mysql.com/doc/refman/8.4/en/nested-join-optimization.html
The following discussion refers to the join syntax described in Section 15.2.13.2, “JOIN Clause”. The syntax of table_factor is extended in comparison with the SQL Standard. The latter accepts only table_reference, not a list of them inside a ...
https://dev.mysql.com/doc/refman/8.4/en/replication-options-gtids.html
The MySQL Server system variables described in this section are used to monitor and control Global Transaction Identifiers (GTIDs). For additional information, see Section 19.1.3, “Replication with Global Transaction Identifiers”.
https://dev.mysql.com/doc/refman/8.4/en/subquery-optimization-with-exists.html
Certain optimizations are applicable to comparisons that use the IN (or =ANY) operator to test subquery results. This section discusses these optimizations, particularly with regard to the challenges that NULL values present. The last part of the ...
https://dev.mysql.com/doc/c-api/8.4/en/c-api-prepared-statement-data-structures.html
Prepared statements use several data structures: To obtain a statement handler, pass a MYSQL connection handler to mysql_stmt_init(), which returns a pointer to a MYSQL_STMT data structure. To specify the statement to prepare, pass the MYSQL_STMT ...
https://dev.mysql.com/doc/mysql-shell/9.4/en/admin-api-routing-guidelines-syntax.html
The top-level properties of a routing guideline document are: destinations: groupings of MySQL servers using pattern-matching expressions. Only online topology members are considered when forming a candidate pool. routes: expressions which match ...
https://dev.mysql.com/doc/mysql-shell/9.4/en/mysql-shell-configuring-options.html
You can configure MySQL Shell to match your preferences, for example to start up to a certain programming language or to provide output in a particular format. Configuration options can be set for the current session only, or options can be set ...
https://dev.mysql.com/doc/workbench/en/wb-properties-palette.html
The Properties palette is used to display and edit the properties of objects on an EER diagram. It is especially useful for editing display objects such as layers and notes. Selecting an object in the EER diagram displays its properties in the ...
https://dev.mysql.com/doc/connectors/en/connector-j-config-failover.html
A failover happens when connection-related errors occur for an underlying, active connection. The connection errors are, by default, propagated to the client, which has to handle them by, for example, recreating the working objects (Statement, ...
https://dev.mysql.com/doc/connectors/en/connector-j-connp-props-connection.html
connectionAttributes A comma-delimited list of user-defined "key:value" pairs, in addition to standard MySQL-defined "key:value" pairs, to be passed to MySQL Server for display as connection attributes in the 'PERFORMANCE_SCHEMA' tables ...
https://dev.mysql.com/doc/connectors/en/connector-j-connp-props-exceptions-warnings.html
dumpQueriesOnException Should the driver dump the contents of the query sent to the server in the message for SQLExceptions? Default Value false Since Version 3.1.3 exceptionInterceptors Comma-delimited list of classes that implement the interface ...