mysql导入CSV表中的数据，但是数据格式不对的问题

[miangmiang咩]

我把csv的数据写入sql，但是原csv表中是数字型的，在我的table中竟然也是数字型的，即使我设置的是varchar,求解

use o2o_stage1_lucky;
create table stage1_train_off(
user_id varchar(32),
merchant_id varchar(32),
coupon_id varchar(32),
discount_rate varchar(32),
distance varchar(32),
date_received varchar(32),
date_id varchar(32)
);

load data infile 'C:/ProgramData/MySQL/MySQL Server 5.7/Uploads/ccf_offline_stage1_train.csv'
into table o2o_stage1_lucky.stage1_train_off
fields terminated by ',' optionally enclosed by '"' escaped by '"'
lines terminated by '\n'

[cptang]

用navicat_premium导入吧 方便快捷