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/sys-ps-setup-save.html
This enables you to alter the configuration temporarily for debugging or other purposes, then restore it to the previous state by invoking the ps_setup_reload_saved() procedure. It is intended you call ps_setup_reload_saved() later within the same ...To prevent other simultaneous calls to save the configuration, ps_setup_save() acquires an advisory lock named sys.ps_setup_save by calling the GET_LOCK() ...
https://dev.mysql.com/doc/refman/8.0/en/validate-password-options-variables.html
If the ALTER USER statement does not provide the existing password in a REPLACE clause, this variable is not enforced. When validate_password.check_user_name is enabled, it has these effects: Checking occurs in all contexts for which ... This ...
https://dev.mysql.com/doc/refman/8.0/en/account-management-statements.html
MySQL account information is stored in the tables of the mysql system schema. Important Some MySQL releases introduce changes to the grant tables to add new privileges or features. To make sure that you can take advantage of any new capabilities, ...This database and the access control system are discussed extensively in Chapter 7, MySQL Server Administration, which you should consult for additional ...
https://dev.mysql.com/doc/refman/8.0/en/charset-metadata.html
This is also true of the contents of tables in INFORMATION_SCHEMA because those tables by definition contain information about database objects. Otherwise, neither the SHOW statements nor SELECT statements for tables in INFORMATION_SCHEMA would work ... Metadata is “the data about the data.” Anything that describes the database—as opposed to being the contents of the database—is ...
https://dev.mysql.com/doc/refman/8.0/en/charset-mysql.html
To display the available character sets, use the INFORMATION_SCHEMA CHARACTER_SETS table or the SHOW CHARACTER SET statement. To list the display collations for a character set, use the INFORMATION_SCHEMA COLLATIONS table or the SHOW COLLATION ...
https://dev.mysql.com/doc/refman/8.0/en/charset-repertoire.html
The repertoire of a character set is the collection of characters in the set. String expressions have a repertoire attribute, which can have two values: ASCII: The expression can contain only ASCII characters; that is, characters in the Unicode ...
https://dev.mysql.com/doc/refman/8.0/en/charset-unicode-utf16.html
The utf16 character set is the ucs2 character set with an extension that enables encoding of supplementary characters: For a BMP character, utf16 and ucs2 have identical storage characteristics: same code values, same encoding, same length. For a ...
https://dev.mysql.com/doc/refman/8.0/en/charset-unicode.html
Beginning with MySQL 8.0.28, utf8mb3 is also displayed in place of utf8 in columns of Information Schema tables, and in the output of SQL SHOW statements. Table 12.2, “Unicode Character Set General Characteristics”, summarizes the general ...
https://dev.mysql.com/doc/refman/8.0/en/comparisons-using-subqueries.html
It finds all rows in table t1 containing a value that occurs twice in a given column: SELECT * FROM t1 AS t WHERE 2 = (SELECT COUNT(*) FROM t1 WHERE t1.id = t.id); For a comparison of the subquery to a scalar, the subquery must return a scalar. The ...
https://dev.mysql.com/doc/refman/8.0/en/constant-folding-optimization.html
Consider the table created by the following statement: CREATE TABLE t (c TINYINT UNSIGNED NOT NULL); The WHERE condition in the query SELECT * FROM t WHERE c < 256 contains the integral constant 256 which is out of range for a TINYINT UNSIGNED ...