MySQL查看表字段备注

查看所有表表名和备注

SELECT TABLE_NAME, TABLE_COMMENT
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_SCHEMA = 'DataBaseName';

查询某张表的字段和备注

SELECT COLUMN_NAME, COLUMN_COMMENT
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME = 'TableName'
AND TABLE_SCHEMA = 'DataBaseName'

查看所有字段名称和备注

SELECT A.TABLE_NAME, A.COLUMN_NAME, A.COLUMN_COMMENT
FROM INFORMATION_SCHEMA.COLUMNS A, 
INFORMATION_SCHEMA.TABLES B
WHERE A.TABLE_NAME = B.TABLE_NAME
AND A.TABLE_SCHEMA = B.TABLE_SCHEMA
AND A.TABLE_SCHEMA='DataBaseName'
ORDER BY A.TABLE_NAME, A.ORDINAL_POSITION;