mysql统计库中有多少表

 排除指定前缀

SELECT COUNT(*) TABLES, table_schema FROM information_schema.TABLES  WHERE table_schema = '数据库名'  AND table_name not LIKE 'bbs_%'; 

只统计指定前缀

SELECT COUNT(*) TABLES, table_schema FROM information_schema.TABLES  WHERE table_schema = '数据库名'  AND table_name LIKE 'bbs_%';