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/rebuilding-tables.html
This section describes how to rebuild or repair tables or indexes, which may be necessitated by: Changes to how MySQL handles data types or character sets. For example, an error in a collation might have been corrected, necessitating a table ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-differing-tables.html
Lossy conversion is handled by inserting only the first N characters of the string on the replica, where N is the width of the target column. Important Replication between columns using different character sets is not supported. Source and target ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-user-names.html
The maximum length for user names in MySQL 8.0 is 32 characters. Replication of user names longer than 16 characters fails when the replica runs a version of MySQL previous to 5.7, because those versions support only shorter user names. This occurs ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-variables.html
sql_mode is also replicated except for the NO_DIR_IN_CREATE mode; the replica always preserves its own value for NO_DIR_IN_CREATE, regardless of changes to it on the source. However, when mysqlbinlog parses a SET @@sql_mode = mode statement, the ...
https://dev.mysql.com/doc/refman/8.0/en/replication-rules-channel-based-filters.html
The pattern used for the --replicate-wild-*-table options can include any characters allowed in identifiers as well as the wildcards % and _. These work the same way as when used with the LIKE operator; for example, tbl% matches any table name ...
https://dev.mysql.com/doc/refman/8.0/en/show-create-database.html
row *************************** Database: test Create Database: CREATE DATABASE `test` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci */ /*!80014 DEFAULT ENCRYPTION='N' */ mysql> SHOW CREATE SCHEMA test\G ... SHOW CREATE {DATABASE ...
https://dev.mysql.com/doc/refman/8.0/en/show-create-user.html
Password hash values displayed in the IDENTIFIED WITH clause of output from SHOW CREATE USER may contain unprintable characters that have adverse effects on terminal displays and in other environments. Hash values that do not contain unprintable ...
https://dev.mysql.com/doc/refman/8.0/en/show.html
SHOW has many forms that provide information about databases, tables, columns, or status information about the server. The pattern is useful for restricting statement output to matching values. Several SHOW statements also accept a WHERE clause ...
https://dev.mysql.com/doc/refman/8.0/en/storage-engine-setting.html
If a table name contains special characters, the names for the table files contain encoded versions of those characters as described in Section 11.2.4, “Mapping of Identifiers to File Names”. When you create a new table, you can specify which ...
https://dev.mysql.com/doc/refman/8.0/en/system-schema.html
row *************************** CATALOG_NAME: def SCHEMA_NAME: mysql DEFAULT_CHARACTER_SET_NAME: utf8mb4 DEFAULT_COLLATION_NAME: utf8mb4_0900_ai_ci SQL_PATH: NULL DEFAULT_ENCRYPTION: NO *************************** 2. row *************************** ...It contains tables that store information required by the MySQL server as it ...