Find logged in users mysql

SELECT SUBSTRING_INDEX(host, ':', 1) AS host_short,
       GROUP_CONCAT(DISTINCT user) AS users,
       COUNT(*) AS threads
FROM information_schema.processlist
GROUP BY host_short
ORDER BY COUNT(*), host_short;

Source: techonthenet.com

Similar codes

0 vote363 views2 answers
Search stored procedures
SQL
0 vote378 views1 answer
C# mysql data reader from two tables
SQL
0 vote372 views1 answer
On delete set default
SQL
0 vote405 views1 answer
Sql statement show all emails with dome
SQL
0 vote342 views1 answer
Kill thread
SQL
1 vote360 views1 answer
How to transfer pandas datafra,e to sqlite
SQL
3 votes500 views9 answers
Linq to sql converter online
SQL
0 vote351 views1 answer
Horizontal join sqlite
SQL
0 vote350 views2 answers
How to know the character set of an oracle databes
SQL
40 votes395 views6 answers
Update table mysql
SQL