Sign InTry Free

Information Functions

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

Information function descriptions

NameDescription
CONNECTION_ID()Return the connection ID (thread ID) for the connection
CURRENT_USER(), CURRENT_USERReturn 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
Download PDF
Playground
New
One-stop & interactive experience of TiDB's capabilities WITHOUT registration.
Products
TiDB
TiDB Dedicated
TiDB Serverless
Pricing
Get Demo
Get Started
© 2024 PingCAP. All Rights Reserved.
Privacy Policy.