#CONNECTION_ID
CONNECTION_ID函数返回当前会话ID,返回值为BIGINT类型。
该函数返回值与INFORMATION_SCHEMA.PROCESSLIST的ID列或SHOW PROCESSLIST命令输出中的ID列同源。
示例(HEAP表)
SELECT CONNECTION_ID() AS id3;
id3
---------------------
34
connection_id::= CONNECTION_ID "("")"
CONNECTION_ID函数返回当前会话ID,返回值为BIGINT类型。
该函数返回值与INFORMATION_SCHEMA.PROCESSLIST的ID列或SHOW PROCESSLIST命令输出中的ID列同源。
示例(HEAP表)
SELECT CONNECTION_ID() AS id3;
id3
---------------------
34

