MySQL查看表的数量

SQL 语句如下，指定好表名即可：

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