CONNECTION_ ID
Warning
SingleStore 9.0 gives you the opportunity to preview, evaluate, and provide feedback on new and upcoming features prior to their general availability. In the interim, SingleStore 8.9 is recommended for production workloads, which can later be upgraded to SingleStore 9.0.
On this page
Returns the unique connection ID of the current connection.
The ID returned by the function will only be unique in the context of a single (child) aggregator, so it cannot be used to uniquely identify sessions cluster-wide.
Syntax
CONNECTION_ID()
Return Type
Integer.
Example
SELECT CONNECTION_ID();
+-----------------+
| CONNECTION_ID() |
+-----------------+
| 171 |
+-----------------+
Last modified: November 8, 2023