Information Functions
TiDB supports most of the information functions available in MySQL 5.7.
Supported functions
Unsupported functions
CHARSET()COERCIBILITY()COLLATION()
You are viewing the documentation of an older version of the TiDB database (TiDB v5.4). It is recommended that you use the latest LTS version of the TiDB database.
TiDB supports most of the information functions available in MySQL 5.7.
| Name | Description |
|---|---|
BENCHMARK() | Execute an expression in a loop |
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 |
ROW_COUNT() | The number of rows affected |
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 |
CHARSET()COERCIBILITY()COLLATION()