PDF (US Ltr)
- 41.8Mb
PDF (A4)
- 41.9Mb
Man Pages (TGZ)
- 272.4Kb
Man Pages (Zip)
- 378.4Kb
Info (Gzip)
- 4.2Mb
Info (Zip)
- 4.2Mb
Search Results
https://dev.mysql.com/doc/refman/9.7/en/mysql-cluster-replication-preparation.html
Use --ndb-replica-batch-size to set the batch size used for writes on the replica instead of --ndb-batch-size, and --ndb-replica-blob-write-batch-bytes rather than --ndb-blob-write-batch-bytes to determine the batch size used by the replication ...
https://dev.mysql.com/doc/refman/9.7/en/replication-features-differing-tables.html
Between any of the binary data types BINARY, VARBINARY, and BLOB, including conversions between different widths. Conversion of a BINARY, VARBINARY, or BLOB to a BINARY, VARBINARY, or BLOB column the same size or larger is never lossy. Source and ...
https://dev.mysql.com/doc/refman/9.7/en/silent-column-changes.html
If strict SQL mode is not enabled, a VARCHAR column with a length specification greater than 65535 is converted to TEXT, and a VARBINARY column with a length specification greater than 65535 is converted to BLOB. Specifying the CHARACTER SET binary ... In some cases, MySQL silently changes column specifications from those given in a CREATE TABLE or ALTER TABLE ...
https://dev.mysql.com/doc/refman/9.7/en/aggregate-functions.html
MySQL bit functions and operators permit binary string type arguments (BINARY, VARBINARY, and the BLOB types) and return a value of like type, which enables them to take arguments and produce return values larger than 64 bits. The result type is ...
https://dev.mysql.com/doc/refman/9.7/en/archive-storage-engine.html
It does support ORDER BY operations, BLOB columns, and spatial data types (see Section 13.4.1, “Spatial Data Types”). The ARCHIVE engine ignores BLOB columns if they are not requested and scans past them while reading. The ARCHIVE storage ...
https://dev.mysql.com/doc/refman/9.7/en/bit-functions.html
(The BIT_AND(), BIT_OR(), and BIT_XOR() aggregate functions are described in Section 14.19.1, “Aggregate Function Descriptions”.) Bit functions and operators permit binary string type arguments (BINARY, VARBINARY, and the BLOB types) and return ... Table 14.17 Bit Functions and Operators Name Description & Bitwise AND >> Right shift << Left shift ^ Bitwise XOR BIT_COUNT() Return the number of bits that are set | Bitwise OR ~ Bitwise inversion The following list describes available bit functions and operators: | Bitwise ...
https://dev.mysql.com/doc/refman/9.7/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. This section describes how the binary collation for binary strings compares to _bin collations for nonbinary strings.
https://dev.mysql.com/doc/refman/9.7/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/9.7/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. For NDB tables, ON DELETE CASCADE is not supported where the child table contains one or more columns of ...
https://dev.mysql.com/doc/refman/9.7/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, ...