mysql 查询 字段的类型

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