MySQL Tutorial/Miscellaneous Functions/Introduction

Miscellaneous Functions

Name Description COUNT() Return a count of the number of rows returned DEFAULT() Return the default value for a table column GET_LOCK() Get a named lock INET_ATON() Return the numeric value of an IP address INET_NTOA() Return the IP address from a numeric value IS_FREE_LOCK() Checks whether the named lock is free IS_USED_LOCK() Checks whether the named lock is in use. Return connection identifier if true. MASTER_POS_WAIT() Block until the slave has read and applied all updates up to the specified position NAME_CONST() Causes the column to have the given name RELEASE_LOCK() Releases the named lock SLEEP() Sleep for a number of seconds UUID() Return a Universal Unique Identifier (UUID) VALUES() Defines the values to be used during an INSERT

Quote: dev.mysql.ru/doc/refman/5.1/en/index.html