-
root@localhost > select concat('KILL ',id,';') from information_schema.processlist where user=’sam' into outfile '/tmp/a.txt
脚本内容如下:
- +------------------------+
- | concat('KILL ',id,';') |
- +------------------------+
- | KILL 31964612; |
- | KILL 31964609; |
- | KILL 31964611; |
- …...
- | KILL 31966619; |
- | KILL 31966620; |
- +------------------------+
- 991 rows in set (0.02 sec)
- root@localhost >
4.执行上面生成的KILL脚本
- root@localhost > source /tmp/a.txt
- Query OK, 0 rows affected (0.00 sec)
- Query OK, 0 rows affected (0.00 sec)
- ……