select concat('KILL ',id,';') from information_schema.processlist where user='root' AND info LIKE '%oc_ir_notice_category%';
select concat('KILL ',id,';') from information_schema.processlist where user='root' AND info LIKE '%oc_ir_notice_category%';
转载于:https://my.oschina.net/colin86/blog/1613295