获取特定 MySQL 数据库中的非空表列表？

SELECT table_type,table_name, table_schema from information_schema.tables
where table_rows >= 1 and table_schema = 'yourDatabaseName';