msyql查看字段备注注释

#db_name为数据库名称,table_name为表名称
SELECT TABLE_SCHEMA 数据库名,table_name 表名 ,COLUMN_NAME as 字段名,column_comment as 字段说明 FROM information_schema.COLUMNS
WHERE TABLE_SCHEMA = 'db_name' AND TABLE_NAME = 'table_name'