mysql 杀会话
Posted by wukaiqiang; tagged with none
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)
Posted by wukaiqiang; tagged with none
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)