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. |
© 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/