获取mysql数据库表字段的备注信息

SELECT COLUMN_NAME as field_name , COLUMN_COMMENT as remark  FROM information_schema.COLUMNS WHERE TABLE_NAME = ‘your_table_name‘

原文：https://www.cnblogs.com/hinq/p/12024094.html