如何统计出mysql数据中的表的总数
SELECT count(*) TABLES, table_schema FROM information_schema.TABLES
where table_schema = '数据名' GROUP BY table_schema;
posted on 2016-03-04 19:31 lianruihong 阅读(623) 评论(0) 编辑 收藏 举报
SELECT count(*) TABLES, table_schema FROM information_schema.TABLES
where table_schema = '数据名' GROUP BY table_schema;
posted on 2016-03-04 19:31 lianruihong 阅读(623) 评论(0) 编辑 收藏 举报