如何查出mysql数据库中数据为空的表
select TABLE_NAME from information_schema.TABLES where TABLE_SCHEMA =‘schemaName’ and TABLE_ROWS = 0;
如何查看链接MySQL数据库的客户端IP
select SUBSTRING_INDEX(host,’:’,1) as ip , count(*) from information_schema.processlist group by ip;
如何查出mysql数据库中数据为空的表
select TABLE_NAME from information_schema.TABLES where TABLE_SCHEMA =‘schemaName’ and TABLE_ROWS = 0;
如何查看链接MySQL数据库的客户端IP
select SUBSTRING_INDEX(host,’:’,1) as ip , count(*) from information_schema.processlist group by ip;