Search Results
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 ...
https://dev.mysql.com/doc/connectors/en/connector-j-connp-props-metadata.html
getProceduresReturnsFunctions Pre-JDBC4 'DatabaseMetaData' API has only the 'getProcedures()' and 'getProcedureColumns()' methods, so they return metadata info for both stored procedures and functions. JDBC4 was extended with the 'getFunctions()' ...
https://dev.mysql.com/doc/connectors/en/connector-j-connp-props-prepared-statements.html
Default Value true Since Version 3.1.12 useServerPrepStmts Use server-side prepared statements if the server supports them? The server may limit the number of prepared statements with 'max_prepared_stmt_count' or disable them altogether. In case of ...