[root@czz ~]# cat /home/mysql/scripts/kill_locked.sql select group_concat(concat(‘kill ‘,id) separator ‘; ‘) as cmd from information_schema.processlist where user=‘test‘; [root@czz ~]#
[root@czz ~]# mysql -utest -p123456 < /home/mysql/scripts/kill_locked.sql mysql: [Warning] Using a password on the command line interface can be insecure. cmd kill 160234; kill 160233; kill 160237; kill 160235; kill 160236; kill 160251; kill 160238; kill 160239 [root@czz ~]#
mysql> \. /home/mysql/scripts/kill_locked.sql +------------------------------------------------------------------------------------------------------------------------------------------------------------+ | cmd | +------------------------------------------------------------------------------------------------------------------------------------------------------------+ | kill 160234; kill 160233; kill 160235; kill 160236; kill 160229; kill 160227; kill 160232; kill 160225 | +------------------------------------------------------------------------------------------------------------------------------------------------------------+ 1 row in set (0.03 sec) mysql> quit
原文：https://www.cnblogs.com/ruigu/p/10756508.html