Miscellaneous functions include DEFAULT, GET_LOCK, SLEEP, UUID, etc.
- 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_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.
- UUID — Returns a Universal Unique Identifier.
- UUID_SHORT — Return short universal identifier.
- VALUES / VALUE — Refer to columns in INSERT ... ON DUPLICATE KEY UPDATE.