Search Results
https://dev.mysql.com/doc/refman/9.7/en/charset-unicode-utf8mb3.html
For example: mysqld --character-set-server=utf8mb3 SET NAMES 'utf8mb3'; /* and other SET statements that have similar effect */ SELECT _utf8mb3 'a'; For information about data type storage as it relates to multibyte character sets, see String Type ... The utf8mb3 character set has these characteristics: Supports BMP characters only (no support for supplementary characters) Requires a maximum of three bytes per multibyte ...
https://dev.mysql.com/doc/refman/9.7/en/checking-gpg-signature.html
Another method of verifying the integrity and authenticity of a package is to use cryptographic signatures. This is more reliable than using MD5 checksums, but requires more work. GnuPG is an Open Source alternative to the well-known Pretty Good ...
https://dev.mysql.com/doc/refman/9.7/en/common-errors.html
Although the problems show up when you try to run client programs, the solutions to many of the problems involves changing the configuration of the MySQL server. This section lists some errors that users frequently encounter when running MySQL ...
https://dev.mysql.com/doc/refman/9.7/en/compiler-characteristics.html
icc (Intel C++ Compiler) Builds A server built with icc has these characteristics: SSL support is not included. In some cases, the compiler used to build MySQL affects the features available for use. The notes in this section apply for binary ...
https://dev.mysql.com/doc/refman/9.7/en/condition-handling.html
For information about how the server chooses handlers when a condition occurs, see Section 15.6.7.6, “Scope Rules for Handlers”. Conditions may arise during stored program execution that require special handling, such as exiting the current ...
https://dev.mysql.com/doc/refman/9.7/en/connection-control-component-installation.html
The Connection Control Component is available in both the Community and Enterprise distributions of MySQL. While it can be used with the default settings, you may wish to tune its operations to meet conditions specific to your environment. The next ...
https://dev.mysql.com/doc/refman/9.7/en/constraint-enum.html
Unless strict mode is disabled (not recommended, but see Section 7.1.11, “Server SQL Modes”), the definition of a ENUM or SET column acts as a constraint on values entered into the column. ENUM and SET columns provide an efficient way to define ...
https://dev.mysql.com/doc/refman/9.7/en/counting-rows.html
Counting the total number of animals you have is the same question as “How many rows are in the pet table?” because there is one record per pet. COUNT(*) counts the number of rows, so the query to count your animals looks like this: mysql> ...
https://dev.mysql.com/doc/refman/9.7/en/daemon-keyring-proxy-plugin.html
MySQL Keyring originally implemented keystore capabilities using server plugins, but began transitioning to use the component infrastructure in MySQL 8.0. The transition includes revising the underlying implementation of keyring plugins to use the ...
https://dev.mysql.com/doc/refman/9.7/en/data-dictionary-limitations.html
Manually created database directories are not recognized by the MySQL Server. This section describes temporary limitations introduced with the MySQL data dictionary. Manual creation of database directories under the data directory (for example, ...