MySQL-查询库表字段信息

-- 查询表及注释
select
	TABLE_NAME
	,TABLE_COMMENT
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_SCHEMA = '库名'

-- 查看字段及注释
SELECT
	COLUMN_NAME
	,COLUMN_COMMENT
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME = '表名'
AND TABLE_SCHEMA = '库名';