mysql查询表名注释、表字段注释

查询表注释
 

SELECT
    TABLE_NAME 表名,
    TABLE_COMMENT 表注释 
FROM
    information_schema.TABLES 
WHERE
    TABLE_SCHEMA = '数据库库名' 
    AND TABLE_COMMENT LIKE '%用户%' 
ORDER BY
    TABLE_NAME;

查询表字段注释：

SELECT
	COLUMN_NAME 字段名,
	column_comment 字段说明,
	column_type 字段类型,
	column_key 约束 
FROM
	information_schema.COLUMNS 
WHERE
	table_schema = '数据库库名' 
	AND table_name = '表名';