查看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编辑  收藏  举报

导航