LOAD DATA LOCAL INFILE 'C:\\baidu_poi_loupan_all_cities.csv'
INTO TABLE test.hh CHARACTER SET gbk
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' ESCAPED BY '"'
LINES TERMINATED BY '\r\n'(
uid,
`name`,
`province`,
city,
district,
street,
address,
telephone,
lat,
lng,
tags,
keyword
)
LOAD DATA LOCAL INFILE ‘Q:\shop.txt’
INTO TABLE ims_ewei_shop_goods CHARACTER SET gbk (goodssn,productsn,title,unit,tcate,marketprice,costprice);