mysql 杀会话
mysql> select concat('KILL ',id,';') from information_schema.processlist where user='root'; |
---|
concat('KILL ',id,';') |
KILL 2476; |
KILL 2447; |
2 rows in set (0.00 sec)
mysql> select concat('KILL ',id,';') from information_schema.processlist where user='root'; |
---|
concat('KILL ',id,';') |
KILL 2476; |
KILL 2447; |
2 rows in set (0.00 sec)
评论已关闭