W3cubDocs

/MariaDB

Miscellaneous Functions

Miscellaneous functions include DEFAULT, GET_LOCK, SLEEP, UUID, etc.

Title Description
GET_LOCK Obtain LOCK.
INET6_ATON Given an IPv6 or IPv4 network address, returns a VARBINARY numeric value.
INET6_NTOA Given an IPv6 or IPv4 network address, returns the address as a nonbinary string.
INET_ATON Returns numeric value of IPv4 address.
INET_NTOA Returns dotted-quad representation of IPv4 address.
IS_FREE_LOCK Checks whether lock is free to use.
IS_IPV4 Whether or not an expression is a valid IPv4 address.
IS_IPV4_COMPAT Whether or not an IPv6 address is IPv4-compatible.
IS_IPV4_MAPPED Whether an IPv6 address is a valid IPv4-mapped address.
IS_IPV6 Whether or not an expression is a valid IPv6 address.
IS_USED_LOCK Check if lock is in use.
MASTER_GTID_WAIT Wait until slave reaches the GTID position.
MASTER_POS_WAIT Blocks until the slave has applied all specified updates.
NAME_CONST Returns the given value.
RELEASE_LOCK Releases lock obtained with GET_LOCK().
SLEEP Pauses for the given number of seconds.
UUID Returns a Universal Unique Identifier.
UUID_SHORT Return short universal identifier.
VALUES / VALUE Refer to columns in INSERT ... ON DUPLICATE KEY UPDATE.
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.

© 2019 MariaDB
Licensed under the Creative Commons Attribution 3.0 Unported License and the GNU Free Documentation License.
https://mariadb.com/kb/en/miscellaneous-functions/