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/year.html
MySQL displays YEAR values in YYYY format, with a range of 1901 to 2155, and 0000. YEAR accepts input values in a variety of formats: As 4-digit strings in the range '1901' to '2155'. The YEAR type is a 1-byte type used to represent year values. It ...
https://dev.mysql.com/doc/refman/8.0/en/account-activity-auditing.html
The User and Host column values in this row uniquely identify the account and correspond to the 'user_name'@'host_name' format in which account names are written in SQL statements. Applications can use the following guidelines to perform SQL-based ...
https://dev.mysql.com/doc/refman/8.0/en/adding-character-set.html
To find the maximum of the currently used collation IDs, use this query: SELECT MAX(ID) FROM INFORMATION_SCHEMA.COLLATIONS; This step depends on whether you are adding a simple or complex character set. Each word within <map> array elements must be ... This section discusses the procedure for adding a character set to ...
https://dev.mysql.com/doc/refman/8.0/en/adding-collation-simple-8bit.html
Each value within the <map> element must be a number in hexadecimal format. This section describes how to add a simple collation for an 8-bit character set by writing the <collation> elements associated with a <charset> character set description in ...
https://dev.mysql.com/doc/refman/8.0/en/alter-server.html
ALTER SERVER server_name OPTIONS (option [, option] ...) Alters the server information for server_name, adjusting any of the options permitted in the CREATE SERVER statement. ALTER SERVER is not written to the binary log, regardless of the logging ...For example, to update the USER option: ALTER SERVER s OPTIONS (USER 'sally'); ALTER SERVER causes an implicit ...
https://dev.mysql.com/doc/refman/8.0/en/analyze-table.html
ANALYZE PARTITION to analyze one or more partitions; for more information, see Section 15.1.9, “ALTER TABLE Statement”, and Section 26.3.4, “Maintenance of Partitions”. Column Value Table The table name Op analyze or histogram Msg_type ...
https://dev.mysql.com/doc/refman/8.0/en/apis-perl.html
These sections contain information about using Perl with MySQL and writing MySQL applications in Perl: For installation instructions for Perl DBI support, see Section 2.10, “Perl Installation Notes”. For online information about Perl DBI, visit ... The Perl DBI module provides a generic interface for database ...
https://dev.mysql.com/doc/refman/8.0/en/archive-storage-engine.html
You can use OPTIMIZE TABLE to analyze the table and pack it into a smaller format (for a reason to use OPTIMIZE TABLE, see later in this section). The ARCHIVE storage engine produces special-purpose tables that store large amounts of unindexed data ...
https://dev.mysql.com/doc/refman/8.0/en/audit-log-filter-definitions.html
For information about using JSON data in MySQL, see Section 13.5, “The JSON Data Type”. An event in the table_access class provides information about a specific type of access to a table. Because field replacement occurs at an early auditing ...
https://dev.mysql.com/doc/refman/8.0/en/audit-log-legacy-filtering.html
The value for either variable can be NULL or a string containing one or more comma-separated account names, each in user_name@host_name format. Note This section describes legacy audit log filtering, which applies if the audit_log plugin is ...