title	summary	category
Information Functions	Learn about the information functions.	user guide

Information Functions

In TiDB, the usage of information functions is similar to MySQL. For more information, see Information Functions.

Information function descriptions

Name	Description
`CONNECTION_ID()`	Return the connection ID (thread ID) for the connection
`CURRENT_USER()`, `CURRENT_USER`	Return the authenticated user name and host name
`DATABASE()`	Return the default (current) database name
`FOUND_ROWS()`	For a `SELECT` with a `LIMIT` clause, the number of the rows that are returned if there is no `LIMIT` clause
`LAST_INSERT_ID()`	Return the value of the `AUTOINCREMENT` column for the last `INSERT`
`SCHEMA()`	Synonym for `DATABASE()`
`SESSION_USER()`	Synonym for `USER()`
`SYSTEM_USER()`	Synonym for `USER()`
`USER()`	Return the user name and host name provided by the client
`VERSION()`	Return a string that indicates the MySQL server version
`TIDB_VERSION()`	Return a string that indicates the TiDB server version