PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/type-conversion.html
For example, MySQL automatically converts strings to numbers as necessary, and vice versa. mysql> SELECT 1+'1'; -> 2 mysql> SELECT CONCAT(2,' test'); -> '2 test' It is also possible to convert a number to a string explicitly using the CAST() ...
https://dev.mysql.com/doc/refman/8.0/en/json-table-functions.html
Beginning with MySQL 8.0.27, this function compares column names in case-insensitive fashion. type is a MySQL scalar data type (that is, it cannot be an object or array). JSON_TABLE() extracts data as JSON then coerces it to the column type, using ... This section contains information about JSON functions that convert JSON data to tabular ...
https://dev.mysql.com/doc/refman/8.0/en/compilation-problems.html
Each time you run CMake, you must run make again to recompile. For instructions on building outside of the source tree, see How to Build MySQL Server with CMake. The following list describes other problems that have been found to occur most often ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-management.html
More detailed information about NDB Cluster operations is available in real time through an SQL interface using the ndbinfo database. mysqld exposes the NDB API statistics counters as system status variables, which can be identified from the prefix ... Managing an NDB Cluster involves a number of tasks, the first of which is to configure and start NDB ...
https://dev.mysql.com/doc/refman/8.0/en/replica-logs-status.html
The connection metadata repository is written to the slave_master_info table in the mysql system schema, and the applier metadata repository is written to the slave_relay_log_info table in the mysql system schema. A warning message is issued if ...
https://dev.mysql.com/doc/refman/8.0/en/sha256-pluggable-authentication.html
For example: $> mysql --ssl-mode=DISABLED -u sha256user -p Enter password: password For this connection attempt by sha256user, the server determines that sha256_password is the appropriate authentication plugin and invokes it (because that was the ... MySQL provides two authentication plugins that implement SHA-256 hashing for user account passwords: caching_sha2_password: Implements SHA-256 authentication (like the deprecated sha256_password), but uses caching on the server side for better performance and has additional features for wider ...
https://dev.mysql.com/doc/refman/8.0/en/constraints.html
MySQL enables you to work both with transactional tables that permit rollback and with nontransactional tables that do not. Because of this, constraint handling is a bit different in MySQL than in other DBMSs. The basic philosophy is that MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-ndb-transid-mysql-connection-map-table.html
The ndb_transid_mysql_connection_map table provides a mapping between NDB transactions, NDB transaction coordinators, and MySQL Servers attached to an NDB Cluster as API nodes. INFORMATION_SCHEMA Name SHOW Name Remarks mysql_connection_id MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-event-reports.html
(This is also sometimes referred to as the log level.) The cluster log can be filtered on these properties using the NDB management client CLUSTERLOG command. The format used in a log message generated by NDB Cluster (as of NDB 8.0.26) is as shown ... In this section, we discuss the types of event logs provided by NDB Cluster, and the types of events that are ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-limitations.html
You can report any discrepancies that you encounter to the MySQL bugs database using the instructions given in Section 1.5, “How to Report Bugs or Problems”. In the sections that follow, we discuss known limitations in current releases of NDB ...