Information, locking, and miscellaneous functions

The following table describes the supported information, locking, and miscellaneous functions.

Function	Description
BENCHMARK	Executes an expression a specified number of times.
CONNECTION_ID	Returns the unique connection identifier for the current session.
FOUND_ROWS	Returns the number of rows found by the last SELECT statement, excluding any LIMIT clause.
GET_LOCK	Obtains a named user-level lock.
IS_FREE_LOCK	Tests whether a named lock is currently free.
IS_USED_LOCK	Returns the connection identifier of the connection that currently holds a specific named lock.
RELEASE_LOCK	Releases the lock named by the specified string that was obtained with GET_LOCK.
SLEEP	Pauses the execution for a specified number of seconds.
UUID	Generates a universally unique identifier (UUID).
UUID_SHORT	Generates a smaller, integer-like version of a UUID.
VERSION	Returns the version of the MySQL server.

For more information, see the MySQL documentation: Information Functions, Locking Functions, and Miscellaneous Functions.