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 |