mysql load data 指定编码

LOAD DATA INFILE 'E://temp//data.txt' IGNORE
INTO TABLE cell_definition_test
CHARACTER SET gbk
FIELDS TERMINATED BY ','
LINES TERMINATED BY '\n' (cgi,msc_id,title,shape_type,lon,lat,radius,angle)