CONNECTION_ID

Return the connection ID. This function retrieves the unique thread identifier for the current client connection.

Syntax

CONNECTION_ID()

Description

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

Returns MYSQL_TYPE_LONG, or int(10).

Examples

SELECT CONNECTION_ID();
+-----------------+
| CONNECTION_ID() |
+-----------------+
|               3 |
+-----------------+

See Also

• SHOW PROCESSLIST

• INFORMATION_SCHEMA.PROCESSLIST

_{This page is licensed: GPLv2, originally from fill_help_tables.sql}