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

6 votes318 views5 answers
Get current date sql
SQL
0 vote349 views1 answer
Psql generate id in existing database
SQL
3 votes353 views1 answer
Export postgres database linux
SQL
2 votes321 views1 answer
Create table with primary key
SQL
0 vote342 views1 answer
Postgresql delete type
SQL
0 vote342 views1 answer
What is the difference between the LIKE and REGEXP operators in mysql?
SQL
0 vote336 views1 answer
Caused by: java.lang.RuntimeException: Unable to obtain credentials to communicate with the Cloud SQL API
SQL
0 vote321 views1 answer
Mysql function variable
SQL
0 vote316 views1 answer
1 column values in to 1 single row in sql
SQL
15 votes340 views5 answers
Show tables in oracle
SQL