mysql5.7 查询数据库有多少张表

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

无可奈何花落去,似曾相识燕归来
原文地址:https://www.cnblogs.com/MUQINGFENG123/p/14821953.html