MySQL Miscellaneous Functions
From w3cyberlearnings
| # | Function | Description |
|---|---|---|
| 1 | DEFAULT | Return the default value for a table column |
| 2 | GET_LOCK | Get a named lock |
| 3 | GTID_SUBSET | Return true if all GTIDs in subset are also in set; otherwise false. |
| 4 | GTID_SUBTRACT | Return all GTIDs in set that are not in subset. |
| 5 | INET_ATON | Return the numeric value of an IP address |
| 6 | INET_NTOA | Return the IP address from a numeric value |
| 7 | INET6_ATON | Return the numeric value of an IPv6 address |
| 8 | INET6_NTOA | Return the IPv6 address from a numeric value |
| 9 | IS_FREE_LOCK | Checks whether the named lock is free |
| 10 | IS_IPV4_COMPAT | Return true if argument is an IPv4-compatible address |
| 11 | IS_IPV4_MAPPED | Return true if argument is an IPv4-mapped address |
| 12 | IS_IPV4 | Return true if argument is an IPv4 address |
| 13 | IS_IPV6 | Return true if argument is an IPv6 address |
| 14 | IS_USED_LOCK | Checks whether the named lock is in use. Return connection identifier if true. |
| 15 | MASTER_POS_WAIT | Block until the slave has read and applied all updates up to the specified position |
| 16 | NAME_CONST | Causes the column to have the given name |
| 17 | RAND | Return a random floating-point value |
| 18 | RELEASE_LOCK | Releases the named lock |
| 19 | SLEEP | Sleep for a number of seconds |
| 20 | UUID_SHORT | Return an integer-valued universal identifier |
| 21 | UUID | Return a Universal Unique Identifier (UUID) |
| 22 | VALUES | Defines the values to be used during an INSERT |
