mysql 查询 字段的类型

select column_name,data_type from information_schema.columns
where table_name = '表名'