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/blob.html
They have the binary character set and collation, and comparison and sorting are based on the numeric values of the bytes in column values. They have a character set other than binary, and values are sorted and compared based on the collation of the ... A BLOB is a binary large object that can hold a variable amount of ...
https://dev.mysql.com/doc/refman/8.0/en/case-sensitivity.html
For binary strings (BINARY, VARBINARY, BLOB), comparisons use the numeric values of the bytes in the operands; this means that for alphabetic characters, comparisons are case-sensitive. Simple comparison operations (>=, >, =, <, <=, sorting, and ...
https://dev.mysql.com/doc/refman/8.0/en/data-size.html
The compact family of row formats also optimizes CHAR column storage when using a variable-length character set such as utf8mb3 or utf8mb4. With ROW_FORMAT=REDUNDANT, CHAR(N) occupies N × the maximum byte length of the character set. Many languages ... Design your tables to minimize their space on the ...
https://dev.mysql.com/doc/refman/8.0/en/dbug-package.html
The debug_options value is a sequence of colon-separated fields: field_1:field_2:...:field_N Each field within the value consists of a mandatory flag character, optionally preceded by a + or - character, and optionally followed by a comma-separated ... The MySQL server and most MySQL clients are compiled with the DBUG package originally created by Fred ...
https://dev.mysql.com/doc/refman/8.0/en/information-functions.html
CHARSET(str) Returns the character set of the string argument, or NULL if the argument is NULL. The return value is a string in the utf8mb3 character set. Within a stored program or view, CURRENT_USER() returns the account for the user who defined ...It may be used to time how quickly MySQL processes the ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-columns-table.html
A UNIQUE index may display as MUL if several columns form a composite UNIQUE index; although the combination of the columns is unique, each column can still hold multiple occurrences of a given value. CHARACTER_OCTET_LENGTH should be the same as ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-memcached-internals.html
table_map_delimiter: The character separating the schema name and the table name when you use the @@ notation in a key name to access a key in a specific table. Multiple columns can be specified using the separator character specified in the ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-memcached-replication.html
Escape character is '^]' set test2 10 0 4 again STORED set test3 10 0 5 again1 STORED Confirm that the two records were replicated to the replica server. Because the daemon_memcached plugin supports the MySQL binary log, source server through the ...
https://dev.mysql.com/doc/refman/8.0/en/myisamchk-repair-options.html
The character set name is implied by the first part of the collation name. The separator character between directory names is the colon (:) on Unix and the semicolon (;) on Windows. --correct-checksum Command-Line Format --correct-checksum Correct ...
https://dev.mysql.com/doc/refman/8.0/en/mysqlbinlog-row-events.html
The combination of --base64-output=DECODE-ROWS and --verbose provides a convenient way to see row events only as SQL statements: $> mysqlbinlog -v --base64-output=DECODE-ROWS log_file ... Character set information is not available in the binary log, ... The following examples illustrate how mysqlbinlog displays row events that specify data ...