最近2018中文字幕在日韩欧美国产成人片_国产日韩精品一区二区在线_在线观看成年美女黄网色视频_国产精品一区三区五区_国产精彩刺激乱对白_看黄色黄大色黄片免费_人人超碰自拍cao_国产高清av在线_亚洲精品电影av_日韩美女尤物视频网站

描述

該語句用來強(qiáng)制結(jié)束 session。

格式

session_stmt:
    KILL [CONNECTION] session_id;

session_id:
    INT_VALUE

參數(shù)解釋

參數(shù)	描述
session_id	要結(jié)束 session 的編號

示例

• 強(qiáng)制結(jié)束編號為 3221502221 和 3221750376 的 session。

OceanBase(admin@test)>show processlist;
+------------+-------+---------------------+------+---------+------+--------+----------------------------------+
| Id         | User  | Host                | db   | Command | Time | State  | Info                             |
+------------+-------+---------------------+------+---------+------+--------+----------------------------------+
| 3221502221 | admin | 100.xx.xx.xx:44775  | test | Sleep   |   10 | SLEEP  | NULL                             |
| 3221502083 | admin | 100.xx.xx.xx:44720  | test | Query   |    0 | ACTIVE | show processlist                 |
| 3221502317 | NULL  | 100.xx.xx.xx:41414  | test | Query   |    0 | ACTIVE | REMOTE/DISTRIBUTE PLAN EXECUTING |
| 3221750377 | NULL  | 100.xx.xx.xx:41414  | test | Query   |    0 | ACTIVE | REMOTE/DISTRIBUTE PLAN EXECUTING |
| 3221750376 | admin | 100.xx.xx.xx:43783  | test | Sleep   |    4 | SLEEP  | NULL                             |
+------------+-------+---------------------+------+---------+------+--------+----------------------------------+
5 rows in set (0.04 sec)

OceanBase(admin@test)>kill 3221502221;
Query OK, 0 rows affected (0.00 sec)

OceanBase(admin@test)>kill connection 3221750376;
Query OK, 0 rows affected (0.05 sec)

文章名稱：創(chuàng)新互聯(lián)OceanBase教程：OceanBaseSESSION
鏈接分享：http://m.fisionsoft.com.cn/article/dhjhhcj.html