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/mathematical-functions.html
ABS(X) Returns the absolute value of X, or NULL if X is NULL. An implication of this is that ABS(-9223372036854775808) produces an error because the result cannot be stored in a signed BIGINT value. mysql> SELECT ABS(2); -> 2 mysql> SELECT ABS(-32); ...
https://dev.mysql.com/doc/refman/8.4/en/myisamchk-repair-options.html
--correct-checksum Command-Line Format --correct-checksum Correct the checksum information for the table. --data-file-length=len, -D len Command-Line Format --data-file-length=len Type Numeric The maximum length of the data file (when re-creating ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-install-debian.html
The section provides information about installing NDB Cluster on Debian and related Linux distributions such Ubuntu using the .deb files supplied by Oracle for this purpose. Oracle also provides an NDB Cluster APT repository for Debian and other ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-ndbd-definition.html
The [ndbd] and [ndbd default] sections are used to configure the behavior of the cluster's data nodes. [ndbd] and [ndbd default] are always used as the section names whether you are using ndbd or ndbmtd binaries for the data node processes. There ...
https://dev.mysql.com/doc/refman/8.4/en/problems-with-mysql-sock.html
The default location for the Unix socket file that the server uses for communication with local clients is /tmp/mysql.sock. (For some distribution formats, the directory might be different, such as /var/lib/mysql for RPMs.) On some versions of ...
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
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 created. SET column values that consist of multiple set members are specified with members ...
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 ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-kill.html
int mysql_kill(MYSQL *mysql, unsigned long pid) Description Note mysql_kill() is deprecated and is subject to removal in a future version of MySQL. mysql_kill() cannot handle values larger than 32 bits; to guard against killing the wrong thread, ...