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