KILL CONNECTION
描述
杀死一个指定连接 ID 的连接。进而会杀死此连接对应的查询。
语法
KILL [ CONNECTION ] <connection_id>必选参数
<connection_id>
链接的 ID。可以通过 SHOW PROCESSLIST 语句查询。
权限控制
执行此 SQL 命令的用户必须是此连接所属的用户，或者至少具有ADMIN_PRIV权限
示例
查询 connection_id:
show processlist;结果如下：
+------------------+----+------+-----------------+---------------------+----------+------+---------+------+-------+-----------------------------------+------------------+--------------+--------------+
| CurrentConnected | Id | User | Host | LoginTime | Catalog | Db | Command | Time | State | QueryId | Info | FE | CloudCluster |
+------------------+----+------+-----------------+---------------------+----------+------+---------+------+-------+-----------------------------------+------------------+--------------+--------------+
| Yes | 16 | root | 127.0.0.1:63746 | 2024-11-04 20:18:07 | internal | test | Query | 0 | OK | e4d69a1cce81468d-91c9ae32b17540e9 | show processlist | 172.16.123.1 | NULL |
+------------------+----+------+-----------------+---------------------+----------+------+---------+------+-------+-----------------------------------+------------------+--------------+--------------+发送 KILL 命令
KILL CONNECTION 16;