MySQL: function 2: Miscellaneous Functions

 

Miscellaneous Functions

Name	Description
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 ()(V4.1.0)	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 ()(V5.0.12)	Causes the column to have the given name
Rand ()	Return a random floating-point value
Release_lock ()	Releases the named lock
Sleep ()(V5.0.12)	Sleep for a number of seconds
Uuid_short ()(V5.1.20)	Return an integer-valued universal identifier
UUID ()(V4.1.2)	Return a universal unique identifier (UUID)
Values ()(V4.1.1)	Defines the values to be used during an insert