Search Results
https://dev.mysql.com/doc/connector-j/en/connector-j-reference-configuration-properties.html
Configuration properties define how Connector/J will make a connection to a MySQL server. Unless otherwise noted, properties can be set for a DataSource object or for a Connection object. If you specify a configuration property in the URL without ...
https://dev.mysql.com/doc/refman/8.4/en/access-control.html
MySQL enables the creation of accounts that permit client users to connect to the server and access data managed by the server. The primary function of the MySQL privilege system is to authenticate a user who connects from a given host and to ...
https://dev.mysql.com/doc/refman/8.4/en/counting-rows.html
COUNT(*) counts the number of rows, so the query to count your animals looks like this: mysql> SELECT COUNT(*) FROM pet; +----------+ | COUNT(*) | +----------+ | 9 | +----------+ Earlier, you retrieved the names of the people who owned pets.
https://dev.mysql.com/doc/refman/8.4/en/gis-polygon-property-functions.html
mysql> SET @poly = ST_GeomFromText('POLYGON((0 0,10 0,10 10,0 10,0 0),(5 5,7 5,7 7,5 7,5 5))'); mysql> SELECT ST_GeometryType(@poly),ST_AsText(ST_Centroid(@poly)); +------------------------+--------------------------------------------+ | ...
https://dev.mysql.com/doc/refman/8.4/en/keyring-system-variables.html
keyring_hashicorp_ca_path Command-Line Format --keyring-hashicorp-ca-path=file_name System Variable keyring_hashicorp_ca_path Scope Global Dynamic Yes SET_VAR Hint Applies No Type File name Default Value empty string The absolute path name of a ...
https://dev.mysql.com/doc/refman/8.4/en/lock-order-tool.html
To enable detection of lock-acquisition deadlocks and enforcement that runtime execution is free of them, MySQL supports LOCK_ORDER tooling. The MySQL server is a multithreaded application that uses numerous internal locking and lock-related ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-list.html
List partitioning in MySQL is similar to range partitioning in many ways. Note In MySQL 8.4, it is possible to match against only a list of integers (and possibly NULL—see Section 26.2.7, “How MySQL Partitioning Handles NULL”) when ...As in ...
https://dev.mysql.com/doc/refman/8.4/en/perl-installation.html
MySQL Perl support requires that you have installed MySQL client programming support (libraries and header files). If you install MySQL from RPM files on Linux, be sure to install the developer RPM as well. For example: $> perl -MCPAN -e shell ...
https://dev.mysql.com/doc/refman/8.4/en/server-side-help-support.html
MySQL Server supports a HELP statement that returns information from the MySQL Reference Manual (see Section 15.8.3, “HELP Statement”). This information is stored in several tables in the mysql schema (see Section 7.3, “The mysql System ...
https://dev.mysql.com/doc/refman/8.4/en/upgrade-paths.html
Notes Make sure you understand the MySQL release model for MySQL for MySQL long long-term support (LTS) and Innovation versions before proceeding with a downgrade. We recommend checking upgrade compatibility with MySQL Shell's Upgrade Checker ...A ...