1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
|
SELECT COUNT(ID) FROM DATA_DICTIONARY.PROCESSLIST WHERE ID != CONNECTION_ID() AND USERNAME="bob" ORDER BY ID;
COUNT(ID)
5
SELECT IF(KILL(id), "YES", "NO") FROM DATA_DICTIONARY.PROCESSLIST WHERE ID != CONNECTION_ID() AND USERNAME="bob";
IF(KILL(id), "YES", "NO")
YES
YES
YES
YES
YES
SELECT count(ID) FROM DATA_DICTIONARY.PROCESSLIST WHERE COMMAND != "Killed" AND USERNAME="bob" and ID != CONNECTION_ID();
count(ID)
0
SELECT KILL(CONNECTION_ID());
ERROR HY000: You cannot kill the session you are connected from.
|