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