CONNECTION_ID()

MySQL 8.4

Returns the connection ID (thread ID) for the connection. Every connection has an ID that is unique among the set of currently connected clients.

Syntax

MYSQL

SELECT CONNECTION_ID();
23786

Examples

Example

The value returned by CONNECTION_ID() is the same type of value as displayed in the ID column of the Information Schema PROCESSLIST table, the Id column of SHOW PROCESSLIST output, and the PROCESSLIST_ID column of the Performance Schema threads table.

MYSQL

SELECT CONNECTION_ID();
23786