mysql 显示表名和表数量

SELECT count(*) FROM information_schema.TABLES WHERE TABLE_SCHEMA='dbname';

SELECT * FROM information_schema.TABLES WHERE TABLE_SCHEMA='dbname';