mysql 用sql语句查询一个表中的所有字段类型、注释

SELECT column_name,column_comment,data_type FROM information_schema.columns WHERE table_name='表名' AND table_schema = "数据库名";