mysql 查询表字段信息(字段名、描述、类型、长度) select column_name,column_comment,data_type,column_type from information_schema.columns where table_name=表名;