查看mysql所有库中表总数量
查看所有:select count(*) tables ,table_schema from information_schema.tables group by table_schema;
查询单个:select count(*) tables ,table_schema from information_schema.tables where table_schema='yingshang' group by table_schema;
posted on 2019-11-26 09:49 shenzen_小白 阅读(1173) 评论(0) 编辑 收藏 举报