mysql查看正在执行的sql语句并将其kill掉

查询当前正在执行
SELECT * FROM information_schema.PROCESSLIST WHERE info IS NOT NULL ORDER BY TIME DESC;
拼接kill sql
SELECT CONCAT( 'kill ',ID ,';') FROM information_schema.PROCESSLIST WHERE info IS NOT NULL AND TIME > 10 
1
2
3
4