Other Functions

These functions of MySQL are ones that we haven't categorized yet, that are very different from other functions, or have don't have similarities to one specific category. Eventually, we'll move them to other sections or rename this section to something that sums up the statements and functions that we can't put elsewhere.

ANALYSE( )

This MySQL function returns an analysis of a results table from a SELECT statement.

BENCHMARK( )

Use this MySQL function to evaluate the performance of a MySQL server.

DATABASE( )

This MySQL function returns the name of the database currently in use for the session.

Use this MySQL function in conjunction with the SQL_CALC_FOUND_ROWS option of a SELECT statement to determine the number of rows an SQL statement using a LIMIT clause would have generated without the limitation.

LAST_INSERT_ID( )

This MySQL function returns the identification number of the last row inserted using the MySQL connection.

ROW_COUNT( )

This MySQL function returns the number of rows changed by the previous SQL statement.

SCHEMA( )

This MySQL function returns the name of the database currently in use for the session.

UUID ( )

This MySQL function returns a Universal Unique Identifier (UUID), a 128-bit number composed of five hexadecimal numbers.

VERSION( )

This MySQL function returns the MySQL server version.