MYSQL中SQL语句查询表字段名、注释、字段类型

select column_name,column_comment,data_type from information_schema.columns where table_name='你的表名'select column_name,column_comment,data_type fro