select concat('KILL ',id,';') from information_schema.processlist where COMMAND='Sleep' and TIME>60; 把内容复制出来执行一遍即可;