表名:TABLE_NAME_[00_30]_[00_30]
查询上表的所有表里数据大于0的表名和条数:
select table_name,table_rows from INFORMATION_SCHEMA.tables
WHERE table_name LIKE 'TABLE_NAME_%'
AND table_rows > 0
表名:TABLE_NAME_[00_30]_[00_30]
查询上表的所有表里数据大于0的表名和条数:
select table_name,table_rows from INFORMATION_SCHEMA.tables
WHERE table_name LIKE 'TABLE_NAME_%'
AND table_rows > 0