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/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/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 ...
https://dev.mysql.com/doc/refman/8.0/en/ldml-collation-example.html
To add a UCA collation for a Unicode character set without recompiling MySQL, use the following procedure. If you are unfamiliar with the LDML rules used to describe the collation's sort characteristics, see Section 12.14.4.2, “LDML Syntax ...The ...
https://dev.mysql.com/doc/refman/8.0/en/audit-log-file-formats.html
<AUDIT_RECORD> <TIMESTAMP>2019-10-03T14:09:43 UTC</TIMESTAMP> <RECORD_ID>11_2019-10-03T14:06:33</RECORD_ID> <NAME>Quit</NAME> <CONNECTION_ID>6</CONNECTION_ID> <STATUS>0</STATUS> <STATUS_CODE>0</STATUS_CODE> <USER>root</USER> <OS_LOGIN/> ... The ...
https://dev.mysql.com/doc/refman/8.0/en/miscellaneous-functions.html
INET_NTOA(expr) Given a numeric IPv4 network address in network byte order, returns the dotted-quad string representation of the address as a string in the connection character set. INET6_NTOA(expr) Given an IPv6 or IPv4 network address represented ...The function return value and type are the same as the return value and type of its argument, but the function result is not checked for the ONLY_FULL_GROUP_BY SQL ...
https://dev.mysql.com/doc/refman/8.0/en/select-into.html
The character_set_filesystem system variable controls the interpretation of the file name. Column values are written converted to the character set specified in the CHARACTER SET clause. If no such clause is present, values are dumped using the ...