PDF (US Ltr)
- 41.8Mb
PDF (A4)
- 41.9Mb
Man Pages (TGZ)
- 272.3Kb
Man Pages (Zip)
- 378.3Kb
Info (Gzip)
- 4.2Mb
Info (Zip)
- 4.2Mb
Search Results
https://dev.mysql.com/doc/refman/9.7/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/9.7/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/9.7/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/9.7/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/9.7/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/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. For discussion about ... This section describes aggregate functions that operate on sets of ...
https://dev.mysql.com/doc/refman/9.7/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/9.7/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/9.7/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 ...
https://dev.mysql.com/doc/refman/9.7/en/replication-features-differing-tables.html
When inserting a value from a BIT(M) column into a BIT(M') column, where M' > M, the most significant bits of the BIT(M') columns are cleared (set to zero) and the M bits of the BIT(M) value are set as the least significant bits of the BIT(M') ...