只需要把下面的库名称修改成需要的库就可以了
SELECT
c.table_name AS '表名',( SELECT TABLE_COMMENT FROM information_schema.TABLES a WHERE a.TABLE_NAME = c.table_name ) AS '表名称',
c.COLUMN_NAME AS '字段',
c.COLUMN_COMMENT AS '字段名称',
IS_NULLABLE AS '是否为空',
COLUMN_TYPE AS '字段类型',
PRIVILEGES AS '字段权限'
FROM
information_schema.COLUMNS c
WHERE
c.table_schema = 'zgwd' -- 库名称
ORDER BY
table_name,
c.ORDINAL_POSITION