要获取特定 MySQL 数据库中的非空表列表,语法如下 -
SELECT table_type,table_name, table_schema from information_schema.tables where table_rows >= 1 and table_schema = 'yourDatabaseName';
要获取特定 MySQL 数据库中的非空表列表,语法如下 -
SELECT table_type,table_name, table_schema from information_schema.tables where table_rows >= 1 and table_schema = 'yourDatabaseName';
之前