PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 296.5Kb
Man Pages (Zip)
- 401.9Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/charset-conversion.html
For successful conversion to occur, one of the following conditions must apply: If the column has a binary data type (BINARY, VARBINARY, BLOB), all the values that it contains must be encoded using a single character set (the character set you're ...
https://dev.mysql.com/doc/refman/8.0/en/create-table-foreign-keys.html
Consequently, BLOB and TEXT columns cannot be included in a foreign key because indexes on those columns must always include a prefix length. As of NDB 8.0.16: For NDB tables, ON DELETE CASCADE is not supported where the child table contains one or ... MySQL supports foreign keys, which permit cross-referencing related data across tables, and foreign key constraints, which help keep the related data ...
https://dev.mysql.com/doc/refman/8.0/en/encryption-functions.html
If you want to store these results, use a column with a VARBINARY or BLOB binary string data type. Use a VARBINARY or BLOB binary string column instead.) If COMPRESS() is invoked from within the mysql client, binary strings display using hexadecimal ...This avoids potential problems with trailing space removal or character set conversion that would change data values, such as may occur if you use a nonbinary string data type (CHAR, VARCHAR, ...
https://dev.mysql.com/doc/refman/8.0/en/faqs-cjk.html
Why do some LIKE and FULLTEXT searches with CJK characters fail? For LIKE searches, there is a very simple problem with binary string column types such as BINARY and BLOB: we must know where characters end. You can also change the data type to BLOB ... This set of Frequently Asked Questions derives from the experience of MySQL's Support and Development groups in handling many inquiries about CJK (Chinese-Japanese-Korean) ...
https://dev.mysql.com/doc/refman/8.0/en/features.html
Data Types Many data types: signed/unsigned integers 1, 2, 3, 4, and 8 bytes long, FLOAT, DOUBLE, CHAR, VARCHAR, BINARY, VARBINARY, TEXT, BLOB, DATE, TIME, DATETIME, TIMESTAMP, YEAR, SET, ENUM, and OpenGIS spatial types. An index may use a prefix of ... This section describes some of the important characteristics of the MySQL Database ...
https://dev.mysql.com/doc/refman/8.0/en/flow-control-functions.html
The second syntax returns the result for the first condition that is true. If no comparison or condition is true, the result after ELSE is returned, or NULL if there is no ELSE part. Note The syntax of the CASE operator described here differs ...
https://dev.mysql.com/doc/refman/8.0/en/innochecksum.html
This tool reads an InnoDB tablespace file, calculates the checksum for each page, compares the calculated checksum to the stored checksum, and reports mismatches, which indicate damaged pages. It was originally developed to speed up verifying the ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-compression-tuning.html
Character strings often compress well, whether defined in CHAR, VARCHAR, TEXT or BLOB columns. If the updates predominantly change non-indexed columns or those containing BLOBs or large strings that happen to be stored “off-page”, the overhead ... Most often, the internal optimizations described in InnoDB Data Storage and Compression ensure that the system runs well with compressed ...
https://dev.mysql.com/doc/refman/8.0/en/internal-temporary-tables.html
Some query conditions prevent the use of an in-memory temporary table, in which case the server uses an on-disk table instead: Presence of a BLOB or TEXT column in the table. The SHOW COLUMNS and DESCRIBE statements use BLOB as the type for some ...
https://dev.mysql.com/doc/refman/8.0/en/json-attribute-functions.html
The functions in this section return attributes of JSON values. An error occurs if the argument is not a valid JSON document. An empty array, empty object, or scalar value has depth 1. A nonempty array containing only elements of depth 1 or ...