MySQL查看表的数量

SQL 语句如下,指定好表名即可:


SELECT COUNT(*) TABLES, table_schema FROM information_schema.TABLES  WHERE table_schema = '<your database>' GROUP BY table_schema;