Skip navigation links
11.11.1 Bit Functions »
Section Navigation      [Toggle]

11.11. Other Functions

[+/-]

11.11.1. Bit Functions
11.11.2. Encryption and Compression Functions
11.11.3. Information Functions
11.11.4. Miscellaneous Functions

Table 11.15. Other Functions

Name Description
AES_DECRYPT() Decrypt using AES
AES_ENCRYPT() Encrypt using AES
BENCHMARK() Repeatedly execute an expression
BIT_COUNT() Return the number of bits that are set
& Bitwise AND
~ Invert bits
| Bitwise OR
^ Bitwise XOR
CHARSET()(v4.1.0) Return the character set of the argument
COERCIBILITY()(v4.1.1) Return the collation coercibility value of the string argument
COLLATION()(v4.1.0) Return the collation of the string argument
COMPRESS()(v4.1.1) Return result as a binary string
CONNECTION_ID() Return the connection ID (thread ID) for the connection
CURRENT_USER(), CURRENT_USER The authenticated user name and host name
DATABASE() Return the default (current) database name
DECODE() Decodes a string encrypted using ENCODE()
DEFAULT() Return the default value for a table column
DES_DECRYPT() Decrypt a string
DES_ENCRYPT() Encrypt a string
ENCODE() Encode a string
ENCRYPT() Encrypt a string
FOUND_ROWS() For a SELECT with a LIMIT clause, the number of rows that would be returned were there no LIMIT clause
GET_LOCK() Get a named lock
INET_ATON() Return the numeric value of an IP address
INET_NTOA() Return the IP address from a numeric value
IS_FREE_LOCK() Checks whether the named lock is free
IS_USED_LOCK()(v4.1.0) Checks whether the named lock is in use. Return connection identifier if true.
LAST_INSERT_ID() Value of the AUTOINCREMENT column for the last INSERT
<< Left shift
MASTER_POS_WAIT() Block until the slave has read and applied all updates up to the specified position
MD5() Calculate MD5 checksum
NAME_CONST()(v5.0.12) Causes the column to have the given name
OLD_PASSWORD()(v4.1) Return the value of the old (pre-4.1) implementation of PASSWORD
PASSWORD() Calculate and return a password string
RAND() Return a random floating-point value
RELEASE_LOCK() Releases the named lock
>> Right shift
ROW_COUNT()(v5.0.1) The number of rows updated
SCHEMA()(v5.0.2) A synonym for DATABASE()
SESSION_USER() Synonym for USER()
SHA1(), SHA() Calculate an SHA-1 160-bit checksum
SLEEP()(v5.0.12) Sleep for a number of seconds
SYSTEM_USER() Synonym for USER()
UNCOMPRESS()(v4.1.1) Uncompress a string compressed
UNCOMPRESSED_LENGTH()(v4.1.1) Return the length of a string before compression
USER() The user name and host name provided by the client
UUID_SHORT()(v5.1.20) Return an integer-valued universal identifier
UUID()(v4.1.2) Return a Universal Unique Identifier (UUID)
VALUES()(v4.1.1) Defines the values to be used during an INSERT
VERSION() Returns a string that indicates the MySQL server version