MySQl

create table train_item (  
    item_id varchar(64), 
    item_geohash varchar(64),
    item_category varchar(64),
    primary key (item_id)  
);  


#载入外部的CSV文件
load data infile ‘D:\\Tmall\\tianchi_mobile_recommend_train_item.csv‘
into table `site`
fields terminated by ‘,‘ optionally enclosed by ‘"‘ escaped by ‘"‘
lines terminated by ‘\n‘;