SELECT count(*) FROM information_schema.TABLES WHERE TABLE_SCHEMA='dbname';
SELECT * FROM information_schema.TABLES WHERE TABLE_SCHEMA='dbname';
SELECT count(*) FROM information_schema.TABLES WHERE TABLE_SCHEMA='dbname';
SELECT * FROM information_schema.TABLES WHERE TABLE_SCHEMA='dbname';
转载于:https://www.cnblogs.com/lansefengmeng/p/6117431.html