mysql> select concat('KILL ',id,';') from information_schema.processlist where user='root';  

+------------------------+  

| concat('KILL ',id,';') |  

+------------------------+  

| KILL 3101;             |  

| KILL 2946;             |  

+------------------------+ 

 2 rows in set (0.00 sec)  


mysql>select concat('KILL ',id,';') from information_schema.processlist where user='mysql_lama' into outfile '/tmp/aa7.txt';  


select concat('KILL ',id,';') from information_schema.processlist where info is not null and user<>'root' and user<>'system user' and time>1  into outfile '/tmp/a132.txt';   


mysql>source /tmp/a.txt;