select concat('kill ', id, ';') as run_this from information_schema.processlist where user = 'root' into outfile '/tmp/kill_process.txt'; #info列表示执行特定sql的连接 select concat('kill ', id, ';') as run_this from information_schema.processlist where user = 'root' and info = 'select * from processlist' into outfile '/tmp/kill_process.txt';