advanced code snippet search

Posted By

r0b0tnic on 01/26/10


Tagged


Versions (?)

Kill all MySQL connections based on condition

 / Published in: MySQL
 
Expand | Embed | Plain Text 
  1. SHOW processlist;
  2. SELECT CONCAT('KILL ',id,';') FROM information_schema.processlist WHERE user='root';

Report this snippet  

You need to login to post a comment.