MENU


Miscellaneous

DEFAULT(column) returns the default value for a table column.
NAME_CONST(name,value) names the column as name and returns value.
BIT_ COUNT(arg) returns the number of set bits in arg.
SLEEP(sec) pauses for sec seconds.

GET_LOCK(str, timeout) tries to obtain a lock named str.
RELEASE_LOCK(str) releases the lock acquired by GET_LOCK().
IS_USED_LOCK(str) returns the client’s connection identifier if str is a used lock, NULL otherwise.
IS_FREE_LOCK(str) returns 1 if no one is using str as a lock, 0 if the lock is in use, NULL if an error occurs.
MASTER_POS_WAIT (log_name, log_pos [,timeout]) blocks until the slave has read and applied all updates up to the specified position in the master log. It returns the number of log events the slave had to wait for to advance to the specified position.

INET_ATON(ip_address) returns an integer representing the IPv4 ip_address.
INET_NTOA(int) returns the dotted-quad ip address represented by int.
INET6_ATON(ip_address) returns a binary string representing the IPv6 ip_address.
INET6_NTOA(str) returns the IPv6 address represented by str.
IS_IPV4(str) returns 1 if str is a valid IPv4 IP address, 0 otherwise.
IS_IPV6(str) returns 1 if str is a valid IPv6 IP address, 0 otherwise.
IS_IPV4_COMPAT(str) returns 1 if str is a valid IPv4-compatible IPv6 address, 0 otherwise. str is a binary string as returned by INET6_ATON().
IS_IPV4_MAPPED(str) returns 1 if str is a valid IPv4-mapped IPv6 address, 0 otherwise. str is a binary string as returned by INET6_ATON().

UUID() returns a Universal Unique Identifier according to DCE 1.1: Remote Procedure Call, CAE Specifications published by The Open Group in October 1997. A UUID is globally unique in space and time. It has a format like: '6ccd780c-baba-1026-9564-0040f4311e29'.
UUID_SHORT() returns a short version of UUID as a 64-bit unsigned integer. It has a format like: 92395783831158784.ExtractValue(xml_frag, xpath_expr) returns the text (CDATA) of the first text node which is a child of the elements of elements matched by the Xpath expression.
UpdateXML(xml_target, xpath_expr, new_xml) replaces a single portion of xml_target matched by xpath_expr with new_xml.