PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/blob.html
These correspond to the four BLOB types and have the same maximum lengths and storage requirements. They have the binary character set and collation, and comparison and sorting are based on the numeric values of the bytes in column values. They have ... A BLOB is a binary large object that can hold a variable amount of ...
https://dev.mysql.com/doc/refman/8.0/en/built-in-function-reference.html
The following table lists each built-in (native) function and operator and provides a short description of each one. For a table listing functions that are loadable at runtime, see Section 14.2, “Loadable Function Reference”. ->> Return value ...
https://dev.mysql.com/doc/refman/8.0/en/caching-sha2-pluggable-authentication.html
The caching_sha2_password plugin has these advantages, compared to sha256_password: On the server side, an in-memory cache enables faster reauthentication of users who have connected previously when they connect again. The database administrator ...
https://dev.mysql.com/doc/refman/8.0/en/charset-connection.html
Some of these have been mentioned in earlier sections: The character_set_server and collation_server system variables indicate the server character set and collation. Exception: For string literals that have an introducer such as _utf8mb4 or ... A ...
https://dev.mysql.com/doc/refman/8.0/en/charset-general.html
Suppose that we have an alphabet with four letters: A, B, a, b. But what if we want to say that the lowercase and uppercase letters are equivalent? Then we would have at least two rules: (1) treat the lowercase letters a and b as equivalent to A and ... A character set is a set of symbols and ...
https://dev.mysql.com/doc/refman/8.0/en/charset-mysql.html
Collations have these general characteristics: Two different character sets cannot have the same collation. The INFORMATION_SCHEMA COLLATIONS table and the SHOW COLLATION statement have a column that indicates for each collation whether it is the ...
https://dev.mysql.com/doc/refman/8.0/en/column-count-limit.html
You have to change some columns to TEXT or BLOBs mysql> CREATE TABLE t (a VARCHAR(10000), b VARCHAR(10000), c VARCHAR(10000), d VARCHAR(10000), e VARCHAR(10000), f VARCHAR(10000), g VARCHAR(6000)) ENGINE=MyISAM CHARACTER SET latin1; ERROR 1118 ...
https://dev.mysql.com/doc/refman/8.0/en/connection-control-plugin-installation.html
If the plugins have been previously registered with INSTALL PLUGIN or are loaded with --plugin-load-add, you can use the --connection-control and --connection-control-failed-login-attempts options at server startup to control plugin activation. The ... This section describes how to install the connection control plugins, CONNECTION_CONTROL and ...
https://dev.mysql.com/doc/refman/8.0/en/connection-interfaces.html
For example, a Windows server that does not have support for named-pipe connections enabled does not create a thread to handle them. To monitor the number of threads in the cache and how many threads have been created because a thread could not be ... This section describes aspects of how the MySQL server manages client ...
https://dev.mysql.com/doc/refman/8.0/en/create-table-ndb-comment-options.html
NDB_COLUMN comments do not support TINYBLOB or TINYTEXT columns, since these have an inline part (only) of fixed size, and no separate parts to store elsewhere. It is also possible to use the ndb_table_no_logging system variable to cause any NDB ...