Mysql 一部分知识

Mysql 部分知识

查看某库的客户端连接IP地址列表：

SELECT SUBSTRING_INDEX(P.HOST,':',1) AS ip FROM information_schema.PROCESSLIST P ?WHERE USER = 'aspnet_user' GROUP BY ip;