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/bit-functions.html
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 ...
https://dev.mysql.com/doc/refman/8.0/en/bit-type.html
The BIT data type is used to store bit values. If you assign a value to a BIT(M) column that is less than M bits long, the value is padded on the left with zeros. For example, assigning a value of b'101' to a BIT(6) column is, in effect, the same ...
https://dev.mysql.com/doc/refman/8.0/en/bit-value-literals.html
In numeric contexts, MySQL treats a bit literal like an integer. To ensure numeric treatment of a bit literal, use it in numeric context. For example, a bit literal assigned to a user-defined variable is a binary string by default. To convert a bit ...A leading 0b is case-sensitive and cannot be written as ...
https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html
block_encryption_mode takes a value in aes-keylen-mode format, where keylen is the key length in bits and mode is the encryption mode. For example, this statement causes the AES encryption functions to use a key length of 256 bits and the CBC mode: ... The MySQL server maintains many system variables that affect its ...
https://dev.mysql.com/doc/refman/8.0/en/adding-collation-simple-8bit.html
This section describes how to add a simple collation for an 8-bit character set by writing the <collation> elements associated with a <charset> character set description in the MySQL Index.xml file. The example adds a collation named latin1_test_ci ...
https://dev.mysql.com/doc/refman/8.0/en/aggregate-functions.html
Prior to MySQL 8.0, bit functions and operators required BIGINT (64-bit integer) arguments and returned BIGINT values, so they had a maximum range of 64 bits. In MySQL 8.0, bit functions and operators permit binary string type arguments (BINARY, ...
https://dev.mysql.com/doc/refman/8.0/en/string-functions.html
mysql> SELECT BIN(12); -> '1100' BIT_LENGTH(str) Returns the length of the string str in bits. mysql> SELECT ELT(1, 'Aa', 'Bb', 'Cc', 'Dd'); -> 'Aa' mysql> SELECT ELT(4, 'Aa', 'Bb', 'Cc', 'Dd'); -> 'Dd' ...For functions that operate on string ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-parameters.html
The default value on 32-bit Windows systems depends on the value of innodb_buffer_pool_size, as described below: If innodb_buffer_pool_size is greater than 1.3GB, the default for innodb_buffer_pool_instances is innodb_buffer_pool_size/128MB, with ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-deadlock-example.html
The following example illustrates how an error can occur when a lock request causes a deadlock. Client A enables innodb_print_all_deadlocks, creates two tables, 'Animals' and 'Birds', and inserts data into each. Thererfore, the previous read-only ...
https://dev.mysql.com/doc/refman/8.0/en/replication-options-binary-log.html
When gtid_mode is not ON, the maximum recommended value is 4GB, due to the fact that, in this case, MySQL cannot work with binary log positions greater than 4GB; when gtid_mode is ON, this limitation does not apply, and the server can work with ...