# 查询所有表的所有字段信息
SELECT *
FROM
information_schema.`COLUMNS`
WHERE table_schema = 'CMIS'
AND table_name IN
(SELECT
table_name
FROM
information_schema.`TABLES`
WHERE table_schema = 'CMIS')
# 查询所有表的所有字段数量总和
SELECT
COUNT(*)
FROM
information_schema.`COLUMNS`
WHERE table_schema = 'CMIS'
AND table_name IN
(SELECT
table_name
FROM
information_schema.`TABLES`
WHERE table_schema = 'CMIS')