mysql查询表内所有字段名和备注

select distinct column_name as 字段名,column_comment as 字段备注 from information_schema.columns where table_schema = '数据库名' and table_name = '表名'