统计mysql数据库中表个数、视图个数、存储过程个数、函数数

#统计表数量
SELECT COUNT(*) TABLES, table_schema FROM information_schema.TABLES   WHERE table_schema LIKE 'dbxj_%' GROUP BY table_schema; 
#存储过程
SELECT db,COUNT(`name`) FROM mysql.proc WHERE db LIKE 'dbxj_%'AND `type` = 'PROCEDURE'  GROUP BY db
#函数
SELECT db,COUNT(`name`) FROM mysql.proc WHERE db LIKE 'dbxj_%'AND `type` = 'FUNCTION'  GROUP BY db
#视图
SELECT table_schema,COUNT(*) views FROM information_schema.VIEWS  WHERE table_schema LIKE 'dbxj_%' GROUP BY table_schema;