Search Results
https://dev.mysql.com/doc/refman/8.4/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.4/en/glossary.html
BLOB An SQL data type (TINYBLOB, BLOB, MEDIUMBLOB, and LONGBLOB) for objects containing any kind of binary data, of arbitrary size. CLOB An SQL data type (TINYTEXT, TEXT, MEDIUMTEXT, or LONGTEXT) for objects containing any kind of character data, of ... These terms are commonly used in information about the MySQL database ...
https://dev.mysql.com/doc/refman/8.4/en/mathematical-functions.html
mysql> SELECT COT(12); -> -1.5726734063977 mysql> SELECT COT(0); -> out-of-range error CRC32(expr) Computes a cyclic redundancy check value and returns a 32-bit unsigned value. mysql> SELECT LOG2(65536); -> 16 mysql> SELECT LOG2(-100); -> NULL ...
https://dev.mysql.com/doc/refman/8.4/en/myisamchk-repair-options.html
--keys-used=val, -k val Command-Line Format --keys-used=val Type Numeric For myisamchk, the option value is a bit value that indicates which indexes to update. Each binary bit of the option value corresponds to a table index, where the first index ...--correct-checksum Command-Line Format --correct-checksum Correct the checksum information for the ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-install-debian.html
Oracle provides .deb installer files for NDB Cluster for 32-bit and 64-bit platforms. In the examples that follow, we assume you wish to install NDB 8.4.6 on a 64-bit Debian 9 system; in this case, the installer file is named ... The section ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-ndbd-definition.html
The arbitrator can be selected from an availability domain in which no data nodes are present, or, if no such availability domain can be found, from a third availability domain. 32-bit operating systems are generally limited to 2−4GB per process; ... The [ndbd] and [ndbd default] sections are used to configure the behavior of the cluster's data ...
https://dev.mysql.com/doc/refman/8.4/en/problems-with-mysql-sock.html
To do this, set the sticky bit on the /tmp directory by logging in as root and using the following command: $> chmod +t /tmp You can check whether the sticky bit is set by executing ls -ld /tmp. If the last permission character is t, the bit is set.
https://dev.mysql.com/doc/refman/8.4/en/replication-binlog-encryption-encryption-keys.html
The binary log encryption keys used to encrypt the file passwords for the log files are 256-bit keys that are generated specifically for each MySQL server instance using MySQL Server's keyring service (see Section 8.4.4, “The MySQL Keyring”).
https://dev.mysql.com/doc/refman/8.4/en/set.html
MySQL stores SET values numerically, with the low-order bit of the stored value corresponding to the first set member. If you retrieve a SET value in a numeric context, the value retrieved has bits set corresponding to the set members that make up ... A SET is a string object that can have zero or more values, each of which must be chosen from a list of permitted values specified when the table is ...
https://dev.mysql.com/doc/refman/8.4/en/windows-restrictions.html
The following restrictions apply to use of MySQL on the Windows platform: Process memory On Windows 32-bit platforms, it is not possible by default to use more than 2GB of RAM within a single process, including MySQL. This is because the physical ...Some versions of Windows have a boot time setting to enable larger applications by reducing the kernel ...