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/adding-collation.html
A collation is a set of rules that defines how to compare and sort character strings. Every character set has at least one collation, and most have two or more collations. Characters with equal weights compare as equal, and characters with unequal ... Warning User-defined collations are deprecated; you should expect support for them to be removed in a future version of ...
https://dev.mysql.com/doc/refman/8.0/en/assigning-passwords.html
Operations that assign or modify passwords are permitted only to users with the CREATE USER privilege, or, alternatively, privileges for the mysql database (INSERT privilege to create new accounts, UPDATE privilege to modify existing accounts). For ... Required credentials for clients that connect to the MySQL server can include a ...
https://dev.mysql.com/doc/refman/8.0/en/audit-log-elements.html
System variables enable audit log configuration and status variables provide runtime operational information. MySQL Enterprise Audit is based on the audit log plugin and related elements: A server-side plugin named audit_log examines auditable ...
https://dev.mysql.com/doc/refman/8.0/en/cache-index.html
Creates 2 key caches named kc_fast and kc_slow Assigns the index for partition p0 to the kc_fast key cache and the index for partitions p1 and p3 to the kc_slow key cache; the index for the remaining partition (p2) uses the server's default key ...| ...
https://dev.mysql.com/doc/refman/8.0/en/charset-collation-information-schema.html
However, for values that correspond to objects that are represented in the file system, such as databases and tables, searches in INFORMATION_SCHEMA string columns can be case-sensitive or case-insensitive, depending on the characteristics of the ...
https://dev.mysql.com/doc/refman/8.0/en/comments.html
This syntax differs slightly from standard SQL comment syntax, as discussed in Section 1.6.2.4, “'--' as the Start of a Comment”. This syntax enables a comment to extend over multiple lines because the beginning and closing sequences need not be ... MySQL Server supports three comment styles: From a # character to the end of the ...
https://dev.mysql.com/doc/refman/8.0/en/comp-err.html
It compiles the errmsg.sys file from text-format error information in MySQL source distributions: As of MySQL 8.0.19, the error information comes from the messages_to_error_log.txt and messages_to_clients.txt files in the share directory. --help, -? ... comp_err creates the errmsg.sys file that is used by mysqld to determine the error messages to display for different error ...
https://dev.mysql.com/doc/refman/8.0/en/create-function-loadable.html
(CREATE FUNCTION is also used to created stored functions; see Section 15.1.17, “CREATE PROCEDURE and CREATE FUNCTION Statements”.) A loadable function is a way to extend MySQL with a new function that works like a native (built-in) MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/create-temporary-table.html
A TEMPORARY table is visible only within the current session, and is dropped automatically when the session is closed. If innodb_strict_mode is disabled, warnings are issued and the temporary table is created using a non-compressed row format. The ... You can use the TEMPORARY keyword when creating a ...
https://dev.mysql.com/doc/refman/8.0/en/data-dictionary.html
In previous MySQL releases, dictionary data was stored in metadata files, nontransactional tables, and storage engine-specific data dictionaries. This chapter describes the main features, benefits, usage differences, and limitations of the data ...