select column_name,data_type from information_schema.COLUMNS whereTABLE_NAME='表名'and column_name = '字段名'