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/charset-binary-collations.html
Binary strings (as stored using the BINARY, VARBINARY, and BLOB data types) have a character set and collation named binary. Nonbinary strings (as stored using the CHAR, VARCHAR, and TEXT data types) have a character set and collation other than ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-online-ddl-operations.html
When you add a primary key using the ALGORITHM=COPY clause, MySQL converts NULL values in the associated columns to default values: 0 for numbers, an empty string for character-based columns and BLOBs, and 0000-00-00 00:00:00 for DATETIME. For ...
https://dev.mysql.com/doc/refman/8.0/en/create-table.html
Character data types (CHAR, VARCHAR, the TEXT types, ENUM, SET, and any synonyms) can include CHARACTER SET to specify the character set for the column. A collation for the character set can be specified with the COLLATE attribute, along with any ...
https://dev.mysql.com/doc/refman/8.0/en/create-index.html
Character sets and collations other than the following two combinations of character set and collation are not supported for multi-valued indexes: The binary character set with the default binary collation The utf8mb4 character set with the default ...However, prefix lengths for index specifications in CREATE TABLE, ALTER TABLE, and CREATE INDEX statements are interpreted as number of characters for nonbinary string types (CHAR, VARCHAR, TEXT) and number of bytes for binary string types (BINARY, VARBINARY, ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-what-is-new.html
A database thus created uses the default MySQL Server database properties (such as those as determined by character_set_database and collation_database) that are in effect on this SQL node at the time the statement is executed. Columns and column ...
https://dev.mysql.com/doc/refman/8.0/en/resource-groups.html
Resource group names are identifiers like table and column names, and need not be quoted in SQL statements unless they contain special characters or are reserved words. Group names are not case-sensitive and may be up to 64 characters long. MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/manual-info.html
This is the Reference Manual for the MySQL Database System, version 8.0, through release 8.0.44. Differences between minor versions of MySQL 8.0 are noted in the present text with reference to release numbers (8.0.x). This manual is not intended ...
https://dev.mysql.com/doc/refman/8.0/en/mysqlpump.html
Note A dump made using PowerShell on Windows with output redirection creates a file that has UTF-16 encoding: mysqlpump [options] > dump.sql However, UTF-16 is not permitted as a connection character set (see Section 12.4, “Connection Character ...
https://dev.mysql.com/doc/refman/8.0/en/json.html
The update can use nested calls to any of the functions listed in the previous item, in any combination, as long as the input and target columns are the same. MySQL handles strings used in JSON context using the utf8mb4 character set and utf8mb4_bin ...The JSON data type provides these advantages over storing JSON-format strings in a string column: Automatic validation of JSON documents stored in JSON ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-programs-ndb-restore.html
The password must be 1 to 256 characters in length, and must be enclosed by single or double quotation marks. It can contain any of the ASCII characters having character codes 32, 35, 38, 40-91, 93, 95, and 97-126; in other words, it can use any ...