#查询MySQL服务中数据库表数据量SELECTCOUNT(*)TABLES, table_schema FROM information_schema.TABLESGROUPBY table_schema;#查询指定数据库表数量SELECTCOUNT(*)TABLES, table_schema FROM information_schema.TABLESWHERE table_schema ='szdb'
查询数据库表数量#查询MySQL服务中数据库表数据量SELECT COUNT(*) TABLES, table_schema FROM information_schema.TABLES GROUP BY table_schema;#查询指定数据库表数量SELECT COUNT(*) TABLES, table_schema FROM information_schema.TABLES WHERE table_schema = 'szdb'查询数据库中的字段,表中的字段#查询一个表中有多少字