show processlist;

desc information_schema.processlist ;

SELECT concat('KILL ',id,';') FROM information_schema.processlist WHERE user='news';

SELECT concat('KILL ',id,';') FROM information_schema.processlist WHERE user='news' INTO OUTFILE 'D:/SOFT_PHP_PACKAGE/mysql/temp/a.txt';

source D:/SOFT_PHP_PACKAGE/mysql/temp/a.txt;