select count(*) TABLES,table schema from information schema .TABLES where table schema ='stjj' group by table schema; --查询数据表
use information_schema;
select table_name,table_rows from TABLES where table schema ='stjj' ORDER BY table rows desc; --查询数据条数
select * from information schema.COLUMNS where table schema ='stjj'; ---查询数据字段