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)