mysql如何查询数据库有多少表？

SELECT count(*) TABLES, table_schema FROM information_schema.TABLES

  where table_schema = '库名' GROUP BY table_schema;

SELECT COUNT(*) TABLES, table_schema FROM information_schema.TABLES  WHERE table_schema = 'test';