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 replica has applied all specified updates. |
| NAME_CONST | Returns the given value. |
| RELEASE_ALL_LOCKS | Releases all named locks held by the current session. |
| RELEASE_LOCK | Releases lock obtained with GET_LOCK(). |
| SLEEP | Pauses for the given number of seconds. |
| SYS_GUID | Returns a globally unique identifier (GUID). |
| 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.
© 2021 MariaDB
Licensed under the Creative Commons Attribution 3.0 Unported License and the GNU Free Documentation License.
https://mariadb.com/kb/en/miscellaneous-functions/