Search Results
https://dev.mysql.com/doc/workbench/en/wb-tutorial-visual-explain-dbt3.html
After reviewing the query again, consider that a multiple-column index can meet the conditions of the WHERE clause that is based on both the o_orderdate and o_clerk columns as the next statement shows. An estimated 18 rows are both scanned and ...
https://dev.mysql.com/doc/workbench/en/wb-tutorials.html
These tutorials show how MySQL Workbench can be used both to design and to document databases. Both these tutorials show the database design capabilities of MySQL Workbench. This chapter contains three short tutorials intended to familiarize you ...
https://dev.mysql.com/doc/workbench/en/wb-what-is-new-8.html
A new option in the Indexes subtab of the table editor (for both the SQL and modeling editors) provides index visibility when it is selected. The OmitSchemas option replaces both the UseShortNames and OmitSchemata options to eliminate the schema ...
https://dev.mysql.com/doc/connectors/en/connector-cpp-installation-binary.html
If you continue the installation, the MSI Installer overview screen enables you to select the type of installation to perform: The Complete installation installs the DLL and Developer components for both connectors. To obtain a Connector/C++ binary ...
https://dev.mysql.com/doc/connectors/en/connector-j-2-way-authentication.html
Apply the steps outlined in both Section 3.5.9.1, “Setting up Server Authentication” and Section 3.5.9.2, “Setting up Client Authentication” to set up a mutual, two-way authentication process in which the server and the client authenticate ...The only requirements are that the CA certificate configured in the server must be able to validate the client certificate and the CA certificate imported into the client truststore must be able to validate the server certificate; the two CA certificates used on the two ends can be ...
https://dev.mysql.com/doc/connectors/en/connector-j-connp-props-high-availability-and-clustering.html
Setting both properties to "0" disables the automatic fall back to the primary host at transaction boundaries. Setting both properties to "0" disables the automatic fall back to the primary host at transaction boundaries. autoReconnect Should the ...
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. For JDBC4 and higher, default "true" value of ...JDBC4 was extended with the 'getFunctions()' and 'getFunctionColumns()' methods and the expected behaviours of previous methods are not well ...
https://dev.mysql.com/doc/connectors/en/connector-j-usagenotes-statements-callable.html
// // Connector/J supports both named and indexed // output parameters. hadResults = cStmt.getMoreResults(); } // // Retrieve output parameters // // Connector/J supports both index-based and // name-based retrieval // int outputValue = ...For more ...
https://dev.mysql.com/doc/connectors/en/connector-net-tutorials-ssl.html
Connector/NET enables the use of either PEM or PFX certificates with both classic MySQL protocol and X Protocol. ssl-ca=path/to/repo/mysql-test/std_data/cacert.pem ssl-cert=path/to/repo/mysql-test/std_data/server-cert.pem ... In this tutorial you ...
https://dev.mysql.com/doc/connectors/en/connector-odbc-installation-binary-deb.html
It installs and registers both the Unicode (MySQL ODBC 9.3 Unicode Driver) and ANSI (MySQL ODBC 9.3 ANSI Driver) drivers. Connector/ODBC Debian packages (.deb files) are available (as of v8.0.20) for Debian or Debian-like Linux systems from the ...