select concat(‘kill ‘,id,’;’) from information_schema.processlist where user=‘root’ and state=‘Waiting for table metadata lock’;
查询被锁的语句组装kill
最新推荐文章于 2024-07-24 16:20:20 发布
select concat(‘kill ‘,id,’;’) from information_schema.processlist where user=‘root’ and state=‘Waiting for table metadata lock’;