---
title: "CONNECTION_ID - OceanBase 数据库 V4.2.1 | OceanBase 文档中心"
description: CONNECTION_ID 声明 CONNECTION_ID() 说明 返回当前会话的 SESSION_ID ，该 ID 是会话在客户端中的唯一标识。 您可以通过 SHOW PROCESSLIST 语句查询当前数据库中会话的数量及会话的 ID。 示例 obclient> select CONNECTION_ID();…
image: https://mdn.alipayobjects.com/huamei_22khvb/afts/img/A*OSPzQ6GUQF4AAAAAQHAAAAgAeiGDAQ/original
---
切换语言

- 中文站 - 简体中文
- International - English
- 日本站 - 日本語

文档反馈![](https://mdn.alipayobjects.com/huamei_22khvb/afts/img/A*P8CuR4UJ_FkAAAAAAAAAAAAADiGDAQ/original) OceanBase 数据库分布式版 - V 4.2.1 LTS

# CONNECTION_ID

更新时间：2026-07-15 20:56:55

[编辑](https://github.com/oceanbase/oceanbase-doc/edit/V4.2.1/zh-CN/700.reference/500.sql-reference/100.sql-syntax/200.common-tenant-of-mysql-mode/400.functions-of-mysql-mode/600.information-functions-of-mysql-mode/500.connection-id-of-mysql-mode.md)  

## 声明

```sql
CONNECTION_ID()

```

## 说明

返回当前会话的 `SESSION_ID`，该 ID 是会话在客户端中的唯一标识。

您可以通过 `SHOW PROCESSLIST` 语句查询当前数据库中会话的数量及会话的 ID。

## 示例

```sql
obclient> select CONNECTION_ID();
+-----------------+
| CONNECTION_ID() |
+-----------------+
|      3221638476 |
+-----------------+
1 row in set

obclient> SELECT SESSION_ID,TRANS_ID FROM oceanbase.__all_virtual_trans_stat WHERE SESSION_ID=CONNECTION_ID();
+------------+------------------------------------------------------------------------------------------+
| SESSION_ID | TRANS_ID                                                                                 |
+------------+------------------------------------------------------------------------------------------+
| 3221638476 | {hash:6868349667767780996, inc:95279944, addr:"xxx.xxx.xx.xxx:xxxx", t:1626333606027937} |
+------------+------------------------------------------------------------------------------------------+
1 row in set

```

 上一篇 下一篇 ![有帮助](https://gw.alipayobjects.com/mdn/ob_asset/afts/img/A*y6ocSqN8cqsAAAAAAAAAAAAAARQnAQ)![无帮助](https://gw.alipayobjects.com/mdn/ob_asset/afts/img/A*BG9IQJyLHF8AAAAAAAAAAAAAARQnAQ)![反馈](https://gw.alipayobjects.com/mdn/ob_asset/afts/img/A*eTWdQKCRKHwAAAAAAAAAAAAAARQnAQ)[AI](https://www.oceanbase.com/obi) 咨询热线